Wrong total values

Dear Community, have the following table below and receive the wrong column values. hope someone can help to fix that calculation. DATE YEAR = Time Table DATE Month = Time Table DATA 1 = DA...

Need Help

MikeUS

Helper I

3 years ago

i have marked the values 5443 and 6998 in the first screenshot

below the table you ask for:

Comment 1) my sales query (=excel database) doesnt allow to see sales per day (MO - SU). i see consolidated one day per months - what is always the first day per months. so dont wonder why you see always DAY 1.

Comment 2) i have selected March and April as well, as Jan and Feb was a bad month without sales for that particulare item. numbers still line up (Quantity total this year vs. Quantity last year)

Comment 3) the table on the bottom is the one you ask for, the one in the top

Comment 4) when i select more months Jan - June, numbers dont line up in the table on the bottom, what makes sense as we compare sales volume 2022 and 2023 and that was different. problem i see - my increase and decrease value is incorrect (marked in red)