Grand Total getting displayed next to each drilled down element

Prasanna M · Mar 31, 2016 2:39AM

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 · Mar 31, 2016 2:54AM

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 · Mar 31, 2016 3:12AM

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 · Mar 31, 2016 7:08AM

Hi,

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

Regards,

Akansh Agarwal

Prasanna M · Apr 2, 2016 6:03AM

Hi Akansh,

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

Prasanna M · Apr 4, 2016 9:38AM

Any thoughts/ideas on this guys.?

Oracle Analytics Forum

Categories

Grand Total getting displayed next to each drilled down element

Answers