Forum Discussion
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...
What you have explained will result in a circular reference error as Cost at product level needs Price to be calculated, so we can't use that same cost to calculate the price again without it being in a separate field/measure /column.
You will need to use something like SUMX ultimately to do what you want.
You will need to use something like SUMX ultimately to do what you want.