Choose from date to date in the pivot table

[Mamdouh Elfors]

Hi
Due to the large amount of data, I resorted to making a pivot table to extract data averages
But I could not make this data by choice from date to date. How can it be done in the pivot table?
File attachment
Thank you

 

[vletm]

Mamdouh Elfors
You should add Date eg to Filters as below ... and after that use Filters as needed

 

[Mamdouh Elfors]

Thanks vletm
I put the date in the filter
But I still cannot access the data from 7/1/2019 to 7/8/2019
Please apply the solution in the attached file
Thanks for attention

 

[vletm]

Mamdouh Elfors
Are Your dates from January to August or about one week?
If one week (Mon to Sun) then You could do it this way ... if 'longer period' then something else...

 

[Mamdouh Elfors]

Thank you so much . vletm
Actually this is what is required. "Data in a week."
But if I want more or less periods - my curiosity drives me to know.
And please, I want how to do it

 

[vletm]

Mamdouh Elfors
... ... ... "Data in a week."
What would 'more and less periods' means for You?
Have You tired to study about Grouping?
You could find some pages from Chandoo.org.

Did You scroll Your data?
In picture, Your needed sum row is selected - okay?
If You want to get nine days period ... then modify 'Number of days:' to ... nine - okay?
Is there something else?
Below that, starts NEXT seven days (week) - okay?
There You could find that weeks sums and so on ... - okay?

 

[Mamdouh Elfors]

vletm
Thank you for your guidance. This is what I saw from you