Bar Chart

[thomas_skariah]

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

[thomas_skariah]

Here i need average of previous quater before week 26.

Any idea?

Regards,

Tom

[#3]

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