Filter a pivot table based on the calculated %

[antodina]

Hello everyone, I would need to filter a pivot table based on the calculated% result in the table. The result I would like to obtain is to display only the records for which the calculated field of the discount percentage is greater than 60%. Thanks in advance to those who can help me. Antonio

[ogautier62 · Accepted solution]

Hi,

you need aggr with something like that :

if(aggr( your calcul of discount percentage,Item) > 60,Item)

with not display null values

regards

[antodina]

thanks

best regards