Using raw data to create Pivot Tables

[rafo77]

Hi,

I am new in here but eager to help and learn in this forum, so far I have reviewed several good topics and I have to say good work everybody!

I have a couple of worksheets containing raw data (one is in text format and the other is a regular table) however I am not able to prepare the pivot tables as requested (have a snapshoot of how they look)

Can anyone enlight me or give me advice? file is in Spanish,, I am attaching snapshots,,

Thanks and Merry Christmas!!!!

[Claymation]

It is more difficult to give you instruction based on a picture of the actual data. Are you able to attach some actual data that we can look at to help you set up the Pivot?

[rafo77]

Yes, you are right,

here is the data:

Source data in Zip file, each worksheet is the correspondent source data for the pivot table showed in Book1 file

Final End in Book1 file

Thanks