Hi All
I need help with the following problem and any advise is appreciate it:
I have a large power Pivot report whci shows the Department Numbers and number of stock (some can be negetive).
I have designed a power Pivot report which has week NO as Column Labels and shows the stocks for each dept No for each week.
What I need is a comparison to see whether the stock has gone up or down compare to the previous week.
I have included a very simple example with normal pivot to see whether I can do this. In this example(in sheet2) I need to subtract the figure for week 25 from Week 24 and show it in a new column (we can name it as progress or anyhting else). and then for week 26 I need to compare w26 (when I get the w26 results) results with w25. My actual filile is power pivot with lots of data. I just want to see how to do this so I can imply it to the main file.
One way which will be acceptable fo my manager is to show the increase or decrease as conditional formatting so that show the increase or decraese with a flag but it should always compare the current week against previous weeks numbers. I hpe this makes sense.
Any help is greatfully apprecaite it.
Bookmarks