Forum Discussion
Wrong total values
>>
Problem: the total amount per year is not correct
Correct is 5443 on line level
Total 6998 aggregate isnt correct<<
I don't see valued 5443 or 6998 on the graph. Not sure what you are talking about.
Let's boil this down to the elements and a very small time slice. Please put together a TABLE visual (NOT a matrix) and filter it for two years, filter it for one month (like January) and for a few days. I want to see the first 5 days of January 2022 and the first five days of January 2023, 10 days total. Then add [Quantity] and [Quantity Last Year].
Does the [Quantity] for January 1, 2022 = [Quantity Last Year] for January 1, 2023?
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)