That was perfect!
I'm so excited, thanks Madhuri!
I was able to replicate on my side with the real dataset but I just like to understand everything that occurs.
Could you elaborate on what you did, or if this is the explanation below:
1.) For the colors when calculating across the table it was separating my categories. When I choose to calculate on category does it lump the categories into 1 big pile? In that circumstance it found something >= 1 returning and colors each category the same accordingly.
2.) Now that every box is the same color, to limit the boxes that appear you place an index filter that only returns 1 of them. I guess the part that confuses me is that if the index calculates off category, and category is now lumped into 1. How is index ever finding a 1-2? Should it just be a 1 to begin with?