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

Question

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

riny_van_eekelen · Answer

larbar110&nbsp;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.&nbsp;All data is stored in "Table1" and the pivot table only sums positive "Values" for each "Ref".

julianchamizo · Answer

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

Forum Discussion

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

2 Replies

Resources