Mutiple Total Lines in Straight Table

[Anonymous]

I have a requirement to create a straight table with multiple 'total' rows at the bottom of the table e.g. one row for the sum, another for the average etc. and cannot find any simple way to do this apart from recreating the straight table with averages and then trying to hide it behind the first straight table with just the averages row showing in the second row. Any pointers would be really appreciated, thanks in advance.

[santhoo_san]

see if this helps

[buzzy996]

i think u can use dimensionality() to do those things.

[Anonymous]

Mucho gracias to santhosh Using the dimension limits is the simplest and most elegant solution here. Thanks a ton!

[Anonymous]

And now I have a second issue to work on, is it possible to show the dimension limit total for only some of the measure columns but not others?

[Anonymous]

Figured that out using dimensionality, thanks to both shiva and santhosh again.