Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys
i have used only() function in the chart expression but i want that when user clear the selection he should be able to see the total data.??????
Hi,
Try using the Aggr() in place of Only().
Regards,
Jagan.
use max() instead of only()
regards
rajni
Hi,
Use:
=if(GetPossibleCount(Field)=Count({1}Field), sum(Expression),sum({$<Field={$(=Only(Field))}>}Expression))
hope this hepl you
Regards,
Arun Goel