KF Aggregation

Hello

I have a key figure (plant capacity) that I have to display on a report. However, when I run the report, the capacity for each week in the month is adding up and the total is displayed. I however want the average of the capacity to show up. Eg- capacity is 500 tons per week, and for the month, I want to show 500 tons and not 2000 tons (as it’s happening now).

I changed the exception aggregation of the KF to “Average of all values”, reference characteristic “Fiscal week”. However it does not work.

Can anyone suggest what I need to do? Note – I am running the report at Fiscal period level and fiscal week is not a characteristic on the report.

Thanks

Marty