Drill in graph changes value on total

[peter.almstrom]

Hi

I have a column graph that has product lines on its x-axis. Ive added a total in the graphs header that shows the total of all the colums in the graph. My problem is that it doesn't work when I drill down, since the total will still show the total from the initial graph.

Ive experimeneted with member sets and i know this i the way forward but I just cant get it to work. Could someone explain how this should be done?

Thanks
/Peter