2 of 2 people found this helpful
One way to do is to use LODs. I also modified [High score / low score] formula by removing the pre-aggregation using FIXED LOD.
See attached workbook
Hope this helps.
Thanks - this was helpful. But ... then I added a dimension (in the bigger version of the file) and I wanted the calc to change for each segment in my dimension. But it just showed the same numbers. So let's say I wanted to take the data in this worksheet and put something like gender in front of it and then see the data reflecting the % of Male vs. Female who scored highly - how would I do that? I think the fixed LOD fixes the calc at one level but I want it to show the breakdown within each segment of the dimension. I keep trying to do a count (respondents) / Total (count (respondents)) calc but it does't seem to work.
All suggestions appreciated. It may be something really simple ...
1 of 1 people found this helpful
Ossai's provided the path - it just needs to be modified to account for any added dimensions -
the way fixed works is it takes all the combinations of dimensions that precede the colon(:) and aggregates them by what follows the colon
the LOD itself is not an aggregate - but rather a higher level disaggregate - OK so what
if you take each of Ossai's expressions and add your additional dimensions (comma separated) before the colon it will accomplish what you want
Pease mark Ossai's answer correct - if mine added any insight please mark it helpful