Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi team,
I have filter, In that i have some values.
Eg:
A
B
C
D
if I select A and B its to display sum(Sales)
If I select A and B and C etc its to display count(Sales)
For Particular Selection, I need to show one measure,
If extra anyone Value is added in the filter it should show other measure...
Thanks in Advance
Hello, could this function be useful to you?
if(GetFieldSelections(field)='A, B',sum(sales),
if(GetFieldSelections(field)='A, B, C',Count(sales)))