Pivot table row percentages

[mattphillip]

Hoping someone may be able to help...

I've built fully customisable straight a pivot tables where the users can specify the visible dimensions as well as the displayed expression (Using variables to display conditional dimensions and expressions). Whilst I've also managed to add column percentages, I haven't found a way to add row percentages without specifying the dimensions statically. This approach isn't practical as the users have 40+ dimensions to choose from.

For example, if the user selects faculty and gender, I want them to be able to see a proportion spread totalling 100% for each faculty (or whichever other two dimensions they choose).

Does anyone have any ideas how I might be able to go about this?

Appreciated.

Matt

[vinieme12]

create a variable to store the Actual Dimension names that the use select

and then pass that variable to with AGGR()

example

SUM( AGGR( SUM( Expression ) ,  $(ListofFields) )

where $(ListofFields) = comma separated fieldnames as STRING.