How can i show the data for the last 3 months on x-axis

[#1]

Hi,

I need to show the data for the last 3 months in a line chart. We need to pick the current month say september, then my requirement is to show july,august,september on x-axis. Plesae suggest.

LOAD

dual(QuarterDetails,Seq) as Month-

3

INLINE

[

MonthName,Seq

QuarterDetails-2,1

QuarterDetails-1,2

QuarterDetails,3

]

SELECT

MONth(GETDATE()) as

QuarterDetails;

Doest this work ?

Regards,

Srihari