Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
I wrote below th use sum, if, distinct function in sheet to make a graph.
=if(Month='Dec' and Name='Jay', distinct(sum(Inf))
but, it is not working.
How should i modify the above sentence?
@PARK_JY You could use a set expression like below to get the desired output:
sum({<Month={'Dec'}, Name={'Jay'}>}distinct inf)
Please let me know if this resolved the issue.
@PARK_JY You could use a set expression like below to get the desired output:
sum({<Month={'Dec'}, Name={'Jay'}>}distinct inf)
Please let me know if this resolved the issue.
Thank you:)!!