Forum Discussion
Turnovers formulas
I would need to make a clustered column chart, on the x-axis it would need to show department and for each department- two columns-Y-axis - turnover yesterday2021 and turnover yesterday2022. For the ...
Unfortunately, the information is sensitive. And it's not in English.
I will try to explain it to you.
I have two tables - Calendar 1 (used formula above to make one) and Query1 (data from Postgresql).
The Query1 table contains columns- date, product id, product name, amount, price etc.
There is a formula for turnover- price * amount.
I have made one relationship between tables Query 1 [date] and Calendar 1 [date] - type many to many.
The rows in Query 1 are not unique.