Calculated column over another over calculated column.

Calculated column over another over calculated column. 

Hello people, I made 2 calculated columns with OVER funcion on a cross table and I Would like to add a 3rd column that is a difference between those 2 calculated column. 

The issue is that the calculated column is like:

Sum([POS_SALES]) / Sum([POS_SALES]) OVER (Intersect(All([Axis.Rows]),[COUNTRY],[Format],[RETAILER])) * 100

and I got 2 values because Horizontal Axis is like <[Axis.Default.Names] NEST [Group]> where group is like A and B. 

(2) Answers

Login