Set analysis or another function?

enrique_farias — Wed, 02 May 2018 15:00:46 GMT

Hello to everyone

I have a pivot table like this:

Columns: field "type_of_account" (which contains sales +, costs -, expenses -)

Rows: client name

Measure: sum(ammount)

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!!

Regards,

Enrique

Re: Set analysis or another function?

sunny_talwar — Wed, 02 May 2018 16:39:59 GMT

May be like this

Sum({<client = {"=Sum({<type_of_account = {'sales +'}>} amount) - Sum({<type_of_account = {'costs -', 'expenses -'}>}amount)"}>} amount)