Chart Dimension Last 3 months

[#1]

Hi All...this may be too simple but I'm totally stuck....

I have 3 data fields - Month, Year, Dollar Value....

I'm trying to create a bar chart...that lists out the Dollar value for the last 3 months (from the maximum possible Month and Year combination)....

In the chart dimension I used the following code to filter out the months but it doesn't seem to work. Any quick ideas please?

If(Addmonths(MakeDate(max([Year]),max([Month])),-3) >=MakeDate([Year],[Month]),Month(MakeDate([Year],[Month])))

[#2 · Accepted solution]

Hi,

1. Create a calculated field

   makedate(year,month)

   
   
   

2. Sort your dimesions according numeric value from sort tab.

3. Go to presentation tab and check the max visibible number option and then enter 3 .

You can also look at the sample.

Best Regars.

[#3]

Thanks very much, Önder....This is exactly what I was looking for...Thank you....