How can I exclude all negative numbers from a grand total in a pivot table?

Occasional Visitor

I am trying to only include positive numbers in this calculation without deleting negative values or hardcoding.




2 Replies

@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".

Screenshot 2021-10-14 at 10.21.01.png

Prepara tus datos por anticipado, crea un nuevo campo, que sea Nevative_Value con los valores TRUE or False. Luego en la tabla dinamica filtra en el encabezado por Negative_value=false