Hi,
We are doing a project for my work.
The project entails a profitability per article. The product structure is a Business Unit has Main Article Groups. A Main Article Group has Article Groups and a Artcile Group has Articles. What we would like to do is to program Pivot Tables for this an scenario on them.
We have in the end a Full Profit and Loss
per Article. To Start i have been programming a little with calculated fields.
What i would like to be able is:
- Set Pivot Fields According to cell entries
( Able to )
- Calculate Fields According to cell entries ( Could use help )
- Simulate Calculated fields with cell entry
For Prep i made the scenario sheets.
- Set the pivot in Original Data ( no Calculated Fields ) or Simulation ( Calculated Fields ), or Combination.
- Set Scenario Models via Different combinations of Above items.
- Select Criteria via ComboBox, CheckBox etc.
Maybe you are getting an idea of where i want to go. I would like to ask if you already worked out something similar for a project? and could help me guiding me through.
For me this is the ideal excel reporting and should not be too difficult, although i have never seen it full blown.
Pivot Table is sheet Control.
greetings,
Jack