how to show Grand total on Top of chart and subtotal at bottom?

[devarasu07]

Hi,

I've Detailed transnational report which has 1000 articles in a table/pivot table view. issue is here i need to show Grand Total at top and Material total (Sub Total) at bottom. how can we achieve this? thanks in advance.

Expected output:

below is the current output:

Thanks

Deva

[sunny_talwar]

You will have to use Pick(Dim....) technique to create Totals instead of using subtotals here

[sunny_talwar · Accepted solution]

Something like the attached