Create a pivot table from database

[mark84]

Hi everybody,
I have a DB like img1.
I d want to create a VBA code to create a pivot table with the fields in the img2.
The field "Somma di AVG PV" is a Calculated Field obtained from the database fields ratio =Imponibile/Qtaevasa.

Could you help me please?
Thank you!

Regards
Marco

 

[ranman256]

click record macro,
create your pivot.
then end macro.

The macro should work as long as you don't have an existing pivot in the workbook.
you may have to increase/decrease row counts before use if the data changes.

 

[mark84]

Thanks for your answer but I’m looking for a vba code that is different from a recorde macro, that’s not dynamic.

could you help me with a dynamic solution?

thanks