Quarter Issue

[vanderson009]

I have below Data Set, I want to plot line chart with Dimension as YearQuarter and Type, Measure is QTY.

But my requirement is to take only latest 12 Quarter i.e. 3 Years. (YearQuarter is in Text format)

YearQuarter	Type	QTY
Q1-13	AB	451
Q2-13	PQ	156
Q3-13	RX	245
Q4-13	ZS	352
Q1-14	VT	154
Q2-14	UV	254
Q3-14	NA	325
Q4-14	YZ	342
Q1-15	MN	315
Q2-15	ZS	421
Q3-15	VT	432
Q4-15	UV	421
Q1-16	NA	412
Q2-16	YZ	142
Q3-16	MN	254
Q4-16	UV	325
Q1-17	NA	342
Q2-17	YZ	315
Q3-17	MN	421
Q4-17	ZS	412
Q1-18	VT	142
Q2-18	UV	254

Please suggest set analysis for this erquirement.

Thanks,

Villyee.

[YoussefBelloum]

Hi,

you can do something like this:

create a counter using autonumber(YearQuarter) and use it on your set analysis

PFA

[vanderson009]

Thanks for your valuable feedback.

Can we have any other option, Cause i will not able to update script. I have to do it on chart level.

Regards,

Villyee

[YoussefBelloum]

I would not recommend it, but here is one way to do it:

=sum({<YearQuarter={"=rank(total right(YearQuarter,2)&Mid(YearQuarter,2,1))<13 and rank(total right(YearQuarter,2)&Mid(YearQuarter,2,1))>=1"}>}QTY)