Hi,
I am trying to show only 8 value(bars) at any given point of time in my bar chart. The X- axes is "Week End Date" and tried to edit axes to select last 8 Date from the data set, however i didn't find any option there.
Any suggestions?
Regards,
Vishwas
5 answers
Make calculation LAST() <= 7 and put it on filter as TRUE, so it will only keep last 8 weeks since LAST() starts with 0,1,2...,6,7
Hope it helps
