Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone.
I have the following graph. Which contains date from previous year that I do not need (2015 and 2016).
How could i get ride of them?
the date column ist "Posting Date".
Cheers
You can add set analysis to your count to ignore those year values. It would looks something like this:
COUNT({<[Year Field]-={2015, 2016}>} [Account No_])
You can add set analysis to your count to ignore those year values. It would looks something like this:
COUNT({<[Year Field]-={2015, 2016}>} [Account No_])
thanks, it worked!