Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
wanted to ask how i can achieve the following task:
If I have a dimension date and I make a selection on any date, I expect that it should show me the cumulative sales from monthstart till the selected date. How I can achieve it?
My suggestion would be to use Set Analysis, or i am wrong?
Thanks,
Patric
For example use this in a text box:
=Sum({<date = {">=$(=Date(MonthStart(Max(date))))<=$(=Date(Max(date)))"}>} sales)
Assuming date and sales are your field names, date dimension is a correctly interpreted date in standard date format.