dimension with quarter & year in bar chart

[prma7799]

Dear All,

I am trying to create one chart like below but not getting perfect picture.

:required output

I have data from 2010-2011 to till ..

But i want only last three year data in chart.

Please find attached calendar script .

Thanks in Advance

[prma7799]

anybody can help on this????

[SreeniJD]

what is the challenge you are facing?

post sample data,if possible

[tresesco]

Something like:

Sum({<FinancialYear, QuarterYear, Year={">=$(=Max(FiscalYear)-2) <=$(=Max(FiscalYear))"}>}Amount)

[prma7799]

PFA...

I want to below output

[prma7799]

Hi tresesco‌

please see the attached file i want dimension as

Q1 11, Q2 11 , Q3 11 ,Q4 11

like this in my attachment when i select particulate year q1 is missing .

and when i am selecting three financial year at a time then it will not come as accepted  output

Thanks

[Anonymous]

Hi ,

Check the attachment.

thanks,

bunny

[tresesco]

Why don't you use QuarterYear as dimension instead of the calculated dimension? And then use set analysis as I suggested above when you need to restrict the time period.