Oracle Analytics and AI

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.