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...
<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...
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...
