Bi Viewer - Totals in Pivot table - Cube View MD

Hi All,

I have a Bi Viewer dashboard where the total for the "NET ASP" column (grey row) is the sum of the submembers. However, this is not correct for the totals [Net Sales / Net Units]. But I'm not really sure how to do it with the current data adapter, Cube View MD.

Just some FYI - The first level of the rows is the products, and the second is the market. 

Did anyone ever face something like this?

Thanks,

Davide