Hi all,

Does anyone have an example of how to replicate a pivot table % of total?

Lets say I have Regions across the columns axis and Products on the rows. I
hoping to get a calc member that replicates the PT % of total as a calc
member. The reason for it is to allow for nesting a dimension in a pivot
table where the % of breaks down.

Thanks in advance!

Can you apply the approach in this MDX code sample?

http://www.tomchester.net/articlesdo...desamples.html

Pushing the MDX Envelope

Code Samples

Email: public (AT) tomchester (DOT) net
...
Flexible Percent of Total

Works with any set and any measure (assumes measure being operated upon
is in first column)
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Hi Deepak,

Thanks for the reply, I actually managed to get it to work with
tuple.currentmember/all.

Great to see Tom's work too, far more elegant. Once worked with him =)

"Deepak Puri" wrote: