Hey Great community!
I have a data with the next columns:
ID_Products, current_sale, original_price, month, year.
I'm using a line chart with 2 dimension:
year on group dimension
month on line dimension.
i'm trying to calculate the current sale of product within each year+month / original price of product within each year only.
i'm using the next syntax: SUM(current_sale)/SUM(total original_price).
my problem is that its taking the original price from all the kind of year and not for each year separately.
any suggestion how to fix it?
Thanks alot!!