Aggregation of Prices in BPS

Hello!

I have two Planning Layouts. One is to plan quantities and prices per year and the other one does the same thing per month.

When I plan per month and then switch to the "year layout", BPS doesn't show the average price but summs up all twelve price records.

Example:

Layout 1:

JAN         FEB         MAR        ...
QUAN PRICE  QUAN PRICE  QUAN PRICE  
15   2.99   18   2.49   12   3.00

Layout 2:

2006
QUAN PRICE
45   8.48

But what I want is:

2006
QUAN PRICE
45   2.83

I have already tried to change the underlying InfoObject (exception aggregation). But that seemed to have no effect at all.

I can't think of any way to get this working. I would think though, that this is a pretty straight forward and common scenario... doesn't it happen often, that people are using BPS to plan with prices (on different levels)? How do you get it to calculate averages instead of sums?

All help is highly appreciated!

Gerrit