Set analysis

[rahulsingh12]

Hi,

In the dimensions I want Year value to always be greater than or equal to 2017.

Currently I have data from 2014.

It is possible to restrict the data in dimension level.

Regards

Rahul

[Anil_Babu_Samineni · Accepted solution]

May be use Calculated Dimension

If(Year >= 2017, Year) // Give it label as Year

[senpradip007]

Try like:

sum({<Year={$(>=(max(Year)))}>} [Your Field])

[prma7799]

Try this in your dimension

=if(Year>=2017,Year)

[Anil_Babu_Samineni]

Why 2014 is not displaying in your case?

[prma7799]

By mistakenly I wrote 2014 in heading ..

Now correct it..