Selection range in Set Analysis

[#1]

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.

[jagan · Accepted solution]

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.

[#3]

Thanks Jagan, that's exactly what I was after.