Pivot Table 2007 + Report Filter question?

pat01

New Member
Joined
Aug 2, 2009
Messages
29
Hi,
I need your help again please.. I do have a consolidated file with the following columns:
State Customer Product Volume Value GP Version


In my "Version" Column I have different versions such as Actual, Forecast, Mth Forecast, Budget, Last Year, 4 Weeks Run Rates TY and 4 Weeks Run Rates LY

How should I layout my consolidated file to provide me with the following pivot table:

In the report field I would like to have a filter selection with the Version New where there would be only selection for Budget, Forecast and Mth Forecast (user can choose only one at the time)

However in my column labels I still want to have my actual, Last Year and 4 Weeks Run Rates visible... Aditionally I would have a Tracking Column which would relate to the selection criteria for Version New field.. .Meaning if the user would select the budget only the key figures for budget would appear same if they would choose forecast etc.... Please find below the example of the print screen...

Customer </SPAN>(All)</SPAN>
Version New</SPAN>(All)</SPAN>
State</SPAN>Values</SPAN>Actual</SPAN>Tracking</SPAN>Last Year</SPAN>4 Weeks TY</SPAN>4 Weeks LY</SPAN>
NSW</SPAN> Net Weight Sold</SPAN>10</SPAN>25</SPAN>8</SPAN>12</SPAN>12</SPAN>
Gross Sales</SPAN>150</SPAN>260</SPAN>120</SPAN>190</SPAN>190</SPAN>
Gross Profit @ Std</SPAN>5</SPAN>12</SPAN>10</SPAN>9</SPAN>9</SPAN>
QLD</SPAN> Net Weight Sold</SPAN>10</SPAN>25</SPAN>8</SPAN>12</SPAN>12</SPAN>
Gross Sales</SPAN>150</SPAN>260</SPAN>120</SPAN>190</SPAN>190</SPAN>
Gross Profit @ Std</SPAN>5</SPAN>12</SPAN>10</SPAN>9</SPAN>9</SPAN>

<TBODY>
</TBODY><COLGROUP><COL><COL><COL span=3><COL><COL></COLGROUP>


Any ideas if this is possible to achieve without using the macros?
Thanks again...
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Watch MrExcel Video

Forum statistics

Threads
1,122,496
Messages
5,596,497
Members
414,072
Latest member
2020914

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top