Pivot Table - Incorrect Partial Sums

[ashish_2511]

Hi There

I'm using a three dimensional pivot table shown below-

Here's the expression i'm using to calculate Cost of actual readings (OMR) -

Column(2)*(

If(

  network_node_type='City',

  Sum(

  {<[MRBC Cost]={'Number of actual readings'}>} [Unit_Cost (City)]

   )

    ,

  (Sum(

  {<[MRBC Cost]={'Number of actual readings'}>} [Unit_Cost (Rural)]

   )

  )))

*network node type is the 3rd dimension and column(2) is not in the snip above(It's towards left)

The partial sums are incorrect. please help.

[sunny_talwar · Accepted solution]

You can try like this:

Sum(Aggr(<Replace Column(2) with the actual expression here> *

If(network_node_type='City',

  Sum({<[MRBC Cost]={'Number of actual readings'}>} [Unit_Cost (City)]),

  Sum({<[MRBC Cost]={'Number of actual readings'}>} [Unit_Cost (Rural)])), Year, Month, [Connection Type]))

[ashish_2511]

Wow! Thanks a ton Sunny.. That worked...

Regards

-Sneh