I want to calculate the share to sales and m2 per row, totals and subtotals. I am using dimensionality but not in big success! There is problem because i am using different and not standard dimensions.
It makes right the % calculation at rows but there is an issue at totals, you can see it is calculated 100% but I want to take the above dimension and calculated to that total. Only the Dimensionality 1 (‘Store’ in my example) should give 100%
I attach the qlik report ‘example_1’ and my excel file ‘data_1’ (look column H(%m2) and K(%Sales) where I am showing the calculation I want to achieve in qlikview. Plz help i am trying for weeks!
I can only work some dynamism on dimension order disabling the possibility to pivot the table (in presentation tab) and using cyclic groups to select the fields, this way I can know wich field is in each dimension and configure the 'total' based on the fields selected for each dimension.
PFA, I only changed the expression for % m2 (and the dimensions, using groups)
