Pivot Table

[#1]

Hi

I need to create a pivot table as in the attachment. The table has data for Market, Qtr, Week, Amount. I need to calculate %change. %change for Q1 09 will be equal to %over. But for Q2 09, %change will be sum of %over of Q1 and Q2 09 grouped by week. For Q3 09, %change is sum of %Over of Q1, Q2 and Q3 09 and so on.

Can anyone help on this.

Thanks

[disqr_rm]

Here you go. Is this what you are looking for?

Rakesh

[#3]

Rakesh. It is correct for Q1 qnd Q2 and the result is exactly what I want. But Q3 result is not as expected. It should be Q1 + Q2 + Q3 of %over.

Thanks

[disqr_rm]

I am sure this can be done on the chart as well using SET , or rowno() or NoOfRows() functions..... and tricky canculations, but it may be better to generate a separate table and link it via Link Table concept to generate such a chart. I will try some more thangs and let you know if I can come up with anything easier for you. Good luck.

[#5]

Thanks. Let me also try.