Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Load * INLINE [
ID,NAME,MONTH,SALES
1,SRI,JAN,100
2,MOM,FEB,200
3,DAD,MARCH,300
4,ROSE,APRIL,400
5,DAM,MAY,500
6,DOSE,JUNE,600
7,PRA,JULY,800
8,ROJA,AUG,450
9,PRASAD,SEP,350
10,SRIKANTH,OCT,480,
11,NIKI,NOV,250
12,SAI,DEC,900
];
I WANT TO SEE ONLY LAST THREE MONTHS OF DATA IN THE BAR CHART
as below
=sum({<ID={">=$(=Max(ID)-2)<=$(=Max(ID))"}>}SALES)
thanks for the input its working