Skip to Content

Subtotal Possition in Crosstab

Hi,

My Requirement is to get the Subtotal in a crosstab at the End of Year Structure Wise like below:

This I achieved it with Hard coding the Measure

=Sum([Measure]) where ([Struct]="0") see the snapshot.

This I want to make it dynamic.

Kindly help.

yndr2.png (143.0 kB)
7wjsi.png (9.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 09, 2017 at 09:18 PM

    Hi,

    Right click on the Year and add a Break. You should see subtotal for every year in the column.

    Thanks,

    Jothi

    Add comment
    10|10000 characters needed characters exceeded