Challenging issue on Pivot table
 

I have pivot table that I am building for many users.
They are allowed to group the columns in different ways.
Now I want to show a graph that automatically adjusts according to the
individual's grouping - BUT, in the graph I want to always show data from the
summary lines regardless of whether the pivot table rows are expanded or
collapsed!