Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm wanting to know whether you can use selection range in set analysis.
What I'm trying to do is:
A user filters the report date to be 01/03/2013 (this could vary).
However for 1 of my graphs, I want it to display data from a fixed start date (01/07/2006) and the current user selection date.
Is this possible?
Thanks in advanced.
Hi,
You can do this by using set analysis
Create a variable with
vSelectedDate = Max(DateDimension)
=Sum({<DateDimension={">=$(Date('01/07/2006'))<=$(=vSelectedDate)"}>} Sales)
Hope this helps you.
Regards,
Jagan.
Hi,
You can do this by using set analysis
Create a variable with
vSelectedDate = Max(DateDimension)
=Sum({<DateDimension={">=$(Date('01/07/2006'))<=$(=vSelectedDate)"}>} Sales)
Hope this helps you.
Regards,
Jagan.
Thanks Jagan, that's exactly what I was after.