Top N Tables On Different Pages of Report Using Same Column to Filter

[Anonymous]

I have this basic data set:

Name	Category	Totals
Todd	Category A	7500
Brian	Category B	5000
Stewart	Category B	4000
Todd	Category A	3000
Chelsea	Category A	1500
Vanessa	Category B	700
Steven	Category B	400
Elliot	Category A	250

On Page 1, I'm doing a breakdown of everything that happened with Category A, and the same on Page 2 with Category B. I'm doing the same table for each breakdown and am doing the Top 3 values for each category, so on Page 1, I'd want this:

Category A Table:

Name	Value
Todd	7500
Stewart	4000
Chelsea	1500

And this on Page 2:

Category B Table:

Name	Value
Brian	5000
Todd	3000
Vanessa	700

Currently, when I do this on the separate pages, it's not showing the Top 3 based on the filters (Page 1 is filtered completely for Category A, Page 2 filtered completely for Category B). It's essentially showing only the top values until it gets to the other category, where it stops counting. Is there a way I can create a measure or a calculated column (preferred) that would allow me to correctly do the tables?

[Anonymous · Accepted solution]

Found the solution! It was as simple taking the Value column and, clicking on the down carrot, change the default "Sum" checkmark and change it to "Don't Summarize." It was grouping all similarly valued items together instead of displaying them separately.