Hi,
The groupby feature works really well when I group by a column that has more than 1 distinct value. It shows the grand total cells for each grouping, and they are meaningful.
However, when there is only one distinct value, I want it to NOT show an ADDITIONAL grand-total row, since it is a duplicate of the previous grouping level.
Is there a way to "merge" duplicate grand total rows so that it only shows the grid doesn't output duplicate rows?
Thanks