Let's take a look at a sample PivotTable below:

SKU $ NewMeasure

111 5 30 (5+ 10 + 15)

222 10 30 (5+ 10 + 15)

333 15 30 (5+ 10 + 15)

SKU $ NewMeasure

111 5 20 (5+ 15)

333 15 20 (5+ 15)

How do I go about defining the "NewMeasure" calculated member in my AS2008 Enterprise cube? The NewMeasure should essentially be the total $ amount for all SKUs in the current PivotTable.

What I'm really after, in this particular example, would be the percentage of a given SKU's $ amount relative to the total $ amount for all SKUs in the current pivot. I figured if I can get the "NewMeasure" logic figured out, the above would
be easy.

In summary, my goal is:

SKU $ NewMeasure NewMeasure2

111 5 30 (5+ 10 + 15) 5/30

222

**View Complete Post**

## Use one cell`s value onto aother Cell to calculate percentage in SSRS 2008

Pls help me with my below issue.

Hi,

I developed SSRS 2008 Matrix Report.

In one of the Rows in the Matrix, First Rows Represent Percentage of Subtotal of Second Rows's Value.In my Matrix , total i have 4 Rows, one of Row need to show a Percentage of Subtotal of Another Row.

How can i Reference that Row Values / Matrix subtotal Values Like that ?

Below is formate of my Matrix SSRS 2008 Report.

Jan Feb March

Mumbai 48% 51% 41% <---Represent of Second Row - Bangalore Percentage of Subtotal

Bangalore 135 192 197

Delhi 149 185 278

Total 284 377 485

How can i reference, One Cell Value from other Cell's and Subtotal for the Percentage Calculation in SSRS 2008 Matrix ?

I would like to calculate percentage for banglore. Such as 135/284.. do you kno what i mean.

Please help me!!

Let me know if need information.

Thanks.

Shalin