Forum Discussion
How can I exclude all negative numbers from a grand total in a pivot table?
I am trying to only include positive numbers in this calculation without deleting negative values or hardcoding.
larbar110 For that you need to load the data to the Data Model and use a DAX measure. Since you do not disclose the structure of your own data (table name, column names etc.), I made a small example as shown in the picture below.
All data is stored in "Table1" and the pivot table only sums positive "Values" for each "Ref".