Hello experts,
I kindly would like to request your help.
In my case I do have two tables with a date and these colums do have multiple lines with values by date. I have assigned a many to many relationship in both directions.
The target is to have a line chart by date which will present the sum per months (or quarter / or year) of both tables.
Table A (Column = Date / Column = QTY)
01/01/2023 = 10
03/01/2023 = 10
04/01/2023 = 10
Table B (Column = Date / Column = QTY)
02/01/2023 = 20
03/01/2023 = 20
05/01/2023 = 20
I would like to bring both tables now in a line chart, presenting the sum per month. Therefore I am adding the date of Table A, the QTY of Table A and QTY of Table B into the chart.
The outcome is Table A = 30 (Sum) and Table B = 20 (Sum). I assume the filter does only accept values with the Dates of Table A?
My desired outcome would be to have the total sum of Table A in JAN and the total sum of Table B in JAN.
I have already tried to change the date format from dd/mm/yyyy to yyyy-mm, but it did not solve the issue.
Do you have any idea?
Thanks a lot!
