Need help -revenue by month & function

[vishwas]

Hi,

I kindly request help. In the attached file there are 2 sheets. Data and output. Data has customer performance details for different months. Customer details has different shipment files for which revenue , cost , margin and the related statistics are captured. Each of the shipment relates to different products. So in the output sheet the user will select the product and than it should show the corresponding revenue , margin and statistics for all the customers in the respective months. Hope I have managed to explain my request.
I would be really appreciate your help.
Thank you

 

[Nebu]

Hi:

Pull a pivot table to achieve this.

Thanks

 

[vishwas]

Hi Nebu,

Firstly,thank you very much for the quick reply. How do I link the pivot as the output format cannot be changed. Once I refresh the pivot , the output should also automatically change. Hope you will help.
Thanks

 

[Nebu]

Hi:

If you do not want to change the output tab use the formula as attached.

Thanks

 

[Nebu]

Hi :

I had wrongly selected the range for GP & Statistics column, I have fixed that in this upload.

Thanks