I have a table chart. It has a sum where the volume is greater than the Min Count using Set Analysis. The table (in Total Mode) counts the rows. You can see it counts to 3. I would like to have the 'Number of unique items selected' to be 3. Is there a way to do this? I want the text below (Number of unique items selected) to reflect a count of 3, and not 1.
Thank you! That worked. I had tried aggr(count. I didn't realize I had it backwards. Thank you!
Try it with: count(aggr(YourExpression, Item))
Thank you! That worked. I had tried aggr(count. I didn't realize I had it backwards. Thank you!