How to calculate row percentage for dimension subtotal?
I have the following data with 20+ measures. Raw data shown here is a sample with only one measure. WIth Tabulate I can get subtotal for each site for all levels of Var2 (0,1,2,3) and level of Var1 (A, B). For example, the subtotal for Site1=461 (438+19+2+2). I am comparing the percentage of measure for each level of Var2 between the level of Var1 for each Site. Table1 presents subtotal for each s...