comparison of the current week total with previous week total in trend chart
Hi,
I would like to present the data trend in which it will compare with previous week. I have 12 weeks of the data, But I need to show latest 4 weeks data trend in chart. But the first week percentage is showing 0 always. for week12=week12 %-week11 %. But for 4th week from week 12 i.e week9 %, it is showing 0, though there is data for week8. I have used aggr(above(sum())) but it is presenting wrong numbers. pls help.
