Hello to everyone
I have a pivot table like this:
Columns: field "type_of_account" (which contains sales +, costs -, expenses -)
Rows: client name
I want to show in the pivot table only the clients which are not profitable, which means (sales-costs-expenses)<0.
Besides, when doing the sum of "type_of_account" it is needed to be filtered for another field, "source" not equal to "XXX".
How can I solve this? I read a lot in the community, but cant figure out which function is needed (aggr? set analysis? if? a combination of them?).
Thank you very much in advance for your help!!