I'm facing an issue regarding the association of data in my pivot table.
I'm displaying the average price for each material split up by months.
I use this calculation to get my average price: avg(TOTAL <MAT_MATERIAL_CODE> aggr(PYprice, MAT_MATERIAL_CODE)) and it works if I show up all the months. When I click on one single month, I get an incorrect value. Normally, the average of all months is the same and I wouldn't expect to change although I click on one single month.
How can I do in order to keep the value fixed regardless the month I click on?
