How to get year range

[sunil-kumar5]

Hi,

I have date from last 15 years and I separated only Years in script.

Now I want to shows year as my dimension but >=2010 so that would start from 2010 to 2020 and so on in future.

I want to create a Bar chart which show dimensions of these years and on the basis of that I can put my measures accordingly.

Please advise.

Thanks

[lironbaram]

hi 

the simple and most intuitive way will be to display all 15 year and allow the user to select the range of years he want to see
but if you want just ten years then you can use one of to option in yours expressions 
1. sum(if(year>=2010,sales))

2.sum({<year=">=2010"}>}sales)

[sunil-kumar5]

Hi Lironbaram,

I already have measure showing the percentage of sales of all years, all I need to show to get dimensions >=2010 where I can put my measure as percentage of sales.

Hope i clarify it.

Thanks

Sunil Kumar