Problem with total summate and partial summate in a straight chart
I have problem with total summate and partial summate in a straight chart.
I upload sales and purchases in some items i don't have sales and in other i don't have purchases for the same period.
The problem is in the column Purchases Amount with AVG Sale Price.
The expression is Purchases Qty*(Sales Amount/Sales Qty)
if you summate the partial rows you have 229,93 and in the total row the chart shows 239,46 with total mode (Expression Total) , if you change the total mode to (Sum of Rows) you have the correct summate 229,93.
The problem begins when i summate only in the customer. In this case the amount does not change i have 239,46