Pivot table for weather

[Mamdouh Elfors]

Dears
In order to get to make a pivot table like this. He had to make Table 2 from Table 1 data
Is it possible to make the same pivot table from Table 1 data directly?
I thank everybody

 

[AlanSidman]

Yes. See attached.

 

[Mamdouh Elfors]

Thank you
AlanSidman

This is a solution that works
But when the choices are made from the field lists
Isn't there a solution by placing options that are on the same table in Filters?

 

[AlanSidman]

Not sure I understand your question. The filter on the is PT is the date which is located at the top of the PT if that is what you are asking. If not, then you need to be more specific as I have no idea what you are asking.

 

[Mamdouh Elfors]

In SheetData, Table 1 contains horizontal data and Table 2 has the same data in a vertical way
The Povit table in a sheet PT from Table 2
I just want to make the Povit table from Table 1 instead of Table 2 (same shape)
I put in the filter Date and cat.