Grand Total getting displayed next to each drilled down element

Prasanna M

Hi friends,

I have an analysis developed which has an output as displayed below. The below is the drilled down view of the report.

I have sorted the report based on the column "Movement from Yesterday" (Sorted Descending).

Due to sorting, the Grand Total is placed below each item apart from placing it at the bottom.

Can I get rid of this by any means, and keep the Grand Total only at the bottom?

If I remove the sorting, I don't face this issue.

Thanks in Advance.

Regards

Prasanna

choracy69

Hi,

It seems that you used there Row Level Grand Total but SubTotal.
Do it this way:
Delete records from the podumowania. Then start again the analysis, go to the tab: Results.
Once you will see the table PPM for the first column: Balance Sheet Category.
I select: Balance Sheet Category -> Show row level Grand Total -> After.

Sorting does not affect the breakdown of the Grand Total.

Prasanna M

Hi,

even now, the sorting is not affecting the grand total.

My issue is, the grand total is being repeated next to each row when drilled down to account level which is not quite appealing for the end user.

Thanks

AkanshAgarwal

Hi,

Try using Value Suppression as Suppress from the column properties of that column.

Regards,

Akansh Agarwal

Prasanna M

Hi Akansh,

I tried that. But it doesnt work. Value Suppression is just to avoid the Duplicate values.

Prasanna M

Any thoughts/ideas on this guys.?