Rank items in Pivot table from high to low and low to high based on the filter selected

Good Afternoon,

I want one chart from my pivot table to show me the ranking and scores. Problem is that not all categories in my filter have the same criteria. Some should be ranked high to low, and some should be ranked low to high.

Any possible solutions to show on my chart what I want when a filter or slicer is selecting the different categories?

"high to low" rank (Gem Rec. POP %, Rel Rate, Knowledge, Courtesy, Effort, Apps)
"low to high" rank (ACW, Hold time)

Jessica