All,
I am attemping to compare a total calculated for a dimension across two groups (in this case the dimension is position and the groups can be called 'A' and 'B') against the overall total. My goal is to determine the percent difference between the A & B groups at a position level and then compare that to the overall percent difference between A & B to see if this individual position performs above or below the average in terms of percent difference in A & B.
Any guidance that can be provided on how this is accomplished (I have tried using set analysis, however it appears this will only override selections, not dimensions within the table) would be greatly appreciated.
Thank you,
Michael
