Discrepancy in pivot table values before and after filtering

[jiayikoh]

Dear community, 

I am encountering a strange issue with my pivot table. You may find the examples below for the incident.

i) I have a pivot table with year(date) on the column while product on the row

ii) I realise that the sum of one of the column is different if I were to have a filter pane on year(date) - before filtering year 2021, the total value for year 2021 (revenue) is 13,042,961; after filtering year 2021, the total value for year 2021 (revenue) is 13,059,796.

You may refer to the screenshot for reference. I would really use your help if this has happened to any of you before. Thank you. 

[hic]

I can see from one of the screenshots that you use a canonical date, which implies that you have multiple date fields in your app.

I would start by checking that you really make the selection in the same field as you have in your pivot table. If you have e.g. shipping date in your chart, but make the selection in e.g. order date, you can get exactly this kind of effects.