Multiple Reporting

[philb99]

Hi - looking for help with regards to multiple reporting.

I have 4 Elements

Business Areas - up to 100
Products - up to 20
UK or Europe
New or Used Product

I am trying to report the volume of all products within each area and whether they are New or Used in UK and Europe

This would be reported as follows

Left Hand side Product and then underneath each Product will be the Business Areas

Four columns where we then reported the volumes in UK or Europe of both New or Used

 

[DanteAmor]

You can create a Pivot table

To create a pivot table you can watch any video on YouTube about creating pivot tables eg.
https://www.youtube.com/watch?v=fp1MUBdgVkc

 

[philb99]

Many thanks - I thought that this might be the only way but I was hoping for a Macro or Formulae - where I am struggling is getting the two columns to the left, both of mine sit underneath each other. Any thoughts please?

 

[DanteAmor]

Select Pivot Table Options / Display / Classic PivotTable Layout

 

[philb99]

Perfect - thank you

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.