My Pivot Table is showing different data

[gilquenanoviii]

Hi everyone, hoping someone can help me with my pivot table problem.
kindly see the highlighted columns in yellow. first screenshot is my main data sheet, where it has datas from Month of June 1 - 30 only.
however when i do the pivot able and include the months, i dont know why it is showing July.

please help.

 

[RoryA]

Hard to tell for sure from pictures but possibilities might be:

• Your dates are not the values you think - e.g. 7/6/2024 is actually 6th July 2024; or
• The data is not refreshed; or
• The data source is not the one you think it is.

 

[gilquenanoviii]

i already tried refreshing data, still the same.. I want it to show just June..

 

[RoryA]

That only addresses one of the possibilities.
I assume the month field is just from date grouping in the pivot table?

 

[gilquenanoviii]

Months field came out after i selected Time in Pivot table fields..

 

[gilquenanoviii]

is there any way where i can upload my file here so anyone could help me figure out my problem

 

[RoryA]

You can upload it to a file sharing site like Dropbox / Google drive or OneDrive and post a link here.

 

[RoryA]

Months field came out after i selected Time in Pivot table fields..

Not Date? In that case, it may be that the time values also include a date that you can't see due to cell formatting.

 

[gilquenanoviii]

JUNE 2024.xlsx

Sheet2 Row Labels,Sum of Sales w/ Tax,Sum of Quantity Jun,-41220335.21,-209347 Jul,-11130958.84,-56939 Grand Total,-52351294.05,-266286

docs.google.com

 

[RoryA]

Yes, all your time values include a date component and from row 211,670 that date is in July.