Filter on Total Column?

MThebeau
MThebeau Member
in Charting

Can you filter on a total column? We are using a pivot table to calculate our selling capacity per areas, per therapist discipline but hoping to remove any that have a TOTAL less than 5 for all of the disciplines in an area combined. Wondering if I am missing a simple filter options vs adding a few more beast mode calculations to make it happen.

Screenshot 2024-01-29 204445.png

Best Answer

  • ColemenWilson
    ColemenWilson Coach
    Answer ✓

    You can do aggregate value filters, but not on the total column - UNLESS the total column is a calculated field (beastmode) and then you can apply the filter to that field directly. Otherwise the filter will be applied to any aggregate value above your threshold.

    If I solved your problem, please select "yes" above

Answers

  • ColemenWilson
    ColemenWilson Coach
    Answer ✓

    You can do aggregate value filters, but not on the total column - UNLESS the total column is a calculated field (beastmode) and then you can apply the filter to that field directly. Otherwise the filter will be applied to any aggregate value above your threshold.

    If I solved your problem, please select "yes" above

Categories