Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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]))
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]))
Wow! Thanks a ton Sunny.. That worked...
Regards
-Sneh