Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Community,
I have a pivot table1 below and need to show a result after two conditions, using set analysis:
1. Show only ID where Sum in column G by whole ID >0
and
2. Sum in column I should be more than 80 from 01/01/2023 to today in column D(Date_End).
So I must to receive a table2:
Help me, please
Regards, Yelena
Something like this: Sum( {<ID={"=aggr(Sum([A]-[B]),ID)>0"}>} [A]-[B])
You can also hide the ID using an calculated Dimension:
If( aggr(Sum([A]-[B]),ID)>0,ID) and then uncheck 'show nulls' on the dimension properties
Something like this: Sum( {<ID={"=aggr(Sum([A]-[B]),ID)>0"}>} [A]-[B])
You can also hide the ID using an calculated Dimension:
If( aggr(Sum([A]-[B]),ID)>0,ID) and then uncheck 'show nulls' on the dimension properties
Thanks a lot 🙂