Forum Discussion
Don't summarize problem
Anonymous
I am not sure if this is what you are facing.
if you have duplicated records in your rawdata, you can change the unit price to average.
if you have same product with different unit price, you can drag both product and unit price to shared axis and drill down to next the unit price level.
Super UserAnonymous
I am not sure if this is what you are facing.
if you have duplicated records in your rawdata, you can change the unit price to average.
if you have same product with different unit price, you can drag both product and unit price to shared axis and drill down to next the unit price level.
I did have duplicated prices and I think that was the problem starting from my data source.
I put the price & cost per every data point instead of having a separate table with prices and costs related to every data point by using their ID_price or ID_cost.
Thank you for the answer!