Sort/Filter Pivot by Value Column 1

[johnnygeo]

Hi, I have a pivot table with 2 row labels (region and category) and a single sum value (cost) column. I would like to show only the rows with the highest total costs.

If I try using the "top 10" feature, I find that I can display all categories for the regions with the highest cost, or the categories with the highest cost for each region, but I can't seem to get the "top 10 region/category combinations". Is this possible? I suppose I could create a calculated field to concatenate region and category, but that seems kind of roundabout.

Another possibility would be to apply a filter to the cost column so it only shows costs > $10,000 or something. But if I put the cost in the report filter, it only lets me filter on the source cost values, as opposed to filtering on the sum of the cost.

Any suggestions?

Thanks,
Johnny Geo

 

[SkipVought]

hi,

right click the left-most row pivot field and select SORT > More options > Descending (Z to A) by the SUM of COST.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[johnnygeo]

great, thanks!