I have a table calculation “Percent of Total” which gives me correct values for individual rows and even the average (using show totals).
Now, I want to Index each row against the average.
Ex:
45.4-48.0 = -2.6 for Gender Woman for row 1
55.1-48.0 = 7.1 for Gender Woman for last row before total.
54.6 - 52.0 = 2.6 for Gender Man for row 1
44.9 - 52.0 = -7.1 for Gender Man for last row before total.
Basically the aim to figure out if each row is below average or above average.
I was able to create a calculation for total average using LAC
sum({cnt_members},[community, gender]) and then doing percent of total table calculation… but when I do
Thank you for the response. Your calculation does resolve the LAC error I was getting, but it still doesn’t provide the difference of a row against average (Indexing).