Skip to Content
0

Subtotal Possition in Crosstab

Jan 05, 2017 at 01:58 PM

15

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Jyothirmayee A Jan 09, 2017 at 09:18 PM
0

Hi,

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

Thanks,

Jothi

Share
10 |10000 characters needed characters left characters exceeded