Filter on Total Column?
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.
Best 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
0
Answers

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
0
Categories
 All Categories
 1.3K Product Ideas
 1.3K Ideas Exchange
 1.4K Connect
 1.1K Connectors
 281 Workbench
 2 Cloud Amplifier
 4 Federated
 2.8K Transform
 81 SQL DataFlows
 541 Datasets
 2.2K Magic ETL
 3.1K Visualize
 2.3K Charting
 510 Beast Mode
 25 Variables
 553 Automate
 129 Apps
 408 APIs & Domo Developer
 16 Workflows
 27 Predict
 11 Jupyter Workspaces
 16 R & Python Tiles
 342 Distribute
 84 Domo Everywhere
 257 Scheduled Reports
 1 Software Integrations
 80 Manage
 79 Governance & Security
 2 Product Release Questions
 Community Forums
 41 Getting Started
 27 Community Member Introductions
 75 Community Announcements
 4.8K Archive