Perform calculation before aggregate in calculated view

[Former Member]

I have a calculation that takes the absolute difference between two measures.  When aggregated everything, it takes the absolute difference of the measures after aggregation. I would like to summarize all the absolute differences at the lowest level rather than summarizing after aggregation.  There is no 'Calculate before aggregation' option in a CV.

[anindya_bose]

Hi Shadi

This option is available in Analytic View.  For calculation view, you can simply define your calculation on a projection node  and pass the calculated KF to Aggregation node.  This should help.

Cheers

Anindya