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.