Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a way to ignore all filters and keep one ?
sum(CA)
HI,
Try like this
=Sum({1< Date={‘>=$(=YearStart(Today()))<=$(=Today())’}>} CA)
Regards,
Jagan.
yes
you can do it for example you want only the country filter you do it like that
sum({1<country=p(country)>}CA)
I need to calculate YTD
Sum({< Date={‘>=$(=YearStart(Today()))<=$(=Today())’}>} CA)
IT WOULD BE sum({1<Date=P{‘>=$(=YearStart(Today()))<=$(=Today())’}>}CA) ? I got always error
hi,
Try:
Sum({<Year=,Month=, Date={‘>=$(=YearStart(Today()))<=$(=Today())’}>} CA)
I have a lot of other fiilters in the other sheets how can I ignore them ?
Sum({1< Date={‘>=$(=YearStart(Today()))<=$(=Today())’}>} CA)
HI,
Try like this
=Sum({1< Date={‘>=$(=YearStart(Today()))<=$(=Today())’}>} CA)
Regards,
Jagan.
this is an interesting answer to your question
Ignore all selections except some specific fields using Set Analysis
Hi,
Please try like this. Hope this will Helpful to you. Thank you.