S
SPIRONIK
For some reason that I do not know I could not read threads but now I a
back.
I would like to thank you for your answer but I think that I confuse
you somehow.
What I actually try to present are the weekly sales of my compan
stores (about 100 stores) and number of customers for each shop, i
contrast with the previous year (2004 vs 2003) for every week and als
YTD for the current week (also 2004 vs 2003) for comparable shops.
I tried to do a pivot, with the following format:
Column A shops, column B 2004 sales for the running week, column C 200
sales for the running week, column D ytd sales for 2004, column E yt
sales for 2003.
In my effort to handle easier data, I thought to use a calculated fiel
adding for YTD every week, e.g. for week 51, I would sum week1+…+week 5
but the calculated field does not let me to add such a big amount o
characters.
My data come from a sheet in which I use a column for the shops, an
one column for each year week sales and customers.
Your solution, as far as I can understand, sums conditionally sales
according to the running week. I read again some of my guides and I wa
not completely sure about the way this formula works. If possible pleas
explain to me how it works,
Thanks again for your time
back.
I would like to thank you for your answer but I think that I confuse
you somehow.
What I actually try to present are the weekly sales of my compan
stores (about 100 stores) and number of customers for each shop, i
contrast with the previous year (2004 vs 2003) for every week and als
YTD for the current week (also 2004 vs 2003) for comparable shops.
I tried to do a pivot, with the following format:
Column A shops, column B 2004 sales for the running week, column C 200
sales for the running week, column D ytd sales for 2004, column E yt
sales for 2003.
In my effort to handle easier data, I thought to use a calculated fiel
adding for YTD every week, e.g. for week 51, I would sum week1+…+week 5
but the calculated field does not let me to add such a big amount o
characters.
My data come from a sheet in which I use a column for the shops, an
one column for each year week sales and customers.
Your solution, as far as I can understand, sums conditionally sales
according to the running week. I read again some of my guides and I wa
not completely sure about the way this formula works. If possible pleas
explain to me how it works,
Thanks again for your time