Dear all,

I would like to know whether I can use OLAP cube and Excel Pivot Table to
contruct the following format of report?

2005-02-06 2004-02-08 Diff 2005-02-07 2004-02-09 Diff
............
Sales 1000 2000 -1000 3000 2500
500
TC 10 40 -30 30 20
10
Avg Sales 100 50 -50 100 125
-25

Actually, I would like to compare the difference of the m th day in the n th
week between two years. If this format can be contruct, how do I design the
dimension, set the measures and calculated members? Is there any reference
about these in the web? Thanks!

Polly