1 of 1 people found this helpful
By creating a calculated field to create the group as opposed to using an ad hoc group will allow you to use it in a calculated field. The following KB article goes into more detail:
Hope this helps!
That was really helpful Tracy, but these groups don't seem to act the same way as the ones I created manually. This is the calculation I've used to create segments based on price:
If [Price]<=34.99 then "D"
Elseif [Price]>=35.00 and [Price]<=54.99 then "C"
Elseif [Price]>=55.00 and [Price]<=84.99 then "B"
Elseif [Price]>=85.00 and [Price]<=149.99 then "A"
The issue is that if I want to view these segments through a lens other than price (say, a count of customers) it doesn't segment based on price and then present the value for the variable that was pulled onto the shelf. I also can't use this calculated field in a calculated field with an IF statement for some reason. Is there something I'm missing with my calculation?
Would you be able to post the workbook or sample workbook (twbx file) so I can take a closer look and maybe come up with a better solution!
I have attached a sample of what I am trying to do. The Second option in the parameter control (Supplier), doesn't work because it is a grouped dimension. I would like it to act as the other two dimensions do in the parameter control.