Display previous Qtr value for Current Qtr bar chart

[#1]

Hi,

I have a requirement that when I select a quarter and year then in Bar chart is should get the values for all the quarters less than and equal to the selected one but the value on the max quarter should be the value of previous quarter,

Eg: If I select 2015 and Q3 then in bar chart I should get three bars i.e Q1,Q2 and Q3 but the value in the bar of Q3 should be the value of Q2 and the value of Q2 should be the value of Q1 and so on (i.e. Current qtr should show the value of previous quarter).

I tried with set analysis but it isn't working.

Please help

Thanks.

[lironbaram]

hi

for me i would have create another qtr dimension in the calnder , that list the -1 quarter for each date

and then simply use this dimension in the chart