Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Can any one give an idea in which i have a weekly sales bar chart,what i need is to display avg of previous quarter before the first week in the bar chart.
In image i need avg of previous quarter before week 26.
Regards,
tom
Here i need average of previous quater before week 26.
Any idea?
Regards,
Tom
Hi hope this help. NOte that in the example I use to variables "vCurrentWeek" and "vWeekPreviousQuarter". They come from the script
LET vCurrentWeek = Week(Today());
LEt vWeekPreviousQuarter = vCurrentWeek-16;
I assume that when you talk about "Previous Quarter" you mean 16 weeks before and not the "natural quarter" : Jan-Mar, Ap-Jun,...
See the file attached