Forum Discussion

siva6063's avatar
siva6063
Regular Visitor
6 years ago

How to do different calculation when drillup

Hi All Thanks in Advance. Im stuck with this requitement, it would be great if i get some help. I have this wiered requirement, that, the drill up to higher level should do a different calculation...
kriscoupe's avatar
kriscoupe
Solution Supplier
6 years ago

Hi siva6063,

 

You'll need to use a SUMX formula for this one. Something along these lines

 

SUMX(

    YourTable,

    Density * Price

)

 

This effectively iterate through all rows of YourTable calculating Density * Price and then adds them all up. This measure should work no matter what level you then drill into.

 

Hope it helps. If I answered your question please mark my answer as a solution so others can find this in the future.

 

Kris