Table and Pivot Table - newbe question

[tygabolu]

Hello,
I am experiencing the following issue: I have created the table with dates, names, results etc. Data contains last week of October and first few days of November. When filtering data to November only the table shows November which is fine but when creating PivotTable and choosing PivotTable fields the date from the table is only from October even when the whole table is highlighted is shows October only. Can anybody help please ?

 

[DJTRIN]

Can you post a sample?

Also consider creating a Date Table. This helps in the long run as it handle your data when filtering by year, quarterly, monthly and daily.

Regard,
DJTRIN

 

[DJTRIN]

Can you post a sample?

Also consider creating a Date Table. This helps in the long run as it handle your data when filtering by year, quarterly, monthly and daily.

Regards,
DJTRIN