Dynamic Series Name/Aggregations

[mrhopko]

Hi All

I hope you can help. I'm struggling to articulate this...

I'm trying to achieve the following:
My data has 3 fields that I use to slice the data in the following heirarchy - Model-Body-Engine.
I have created a simple line chart that includes these 3 fields in the legend so that each combination has its own line/series (sales over time)
I then use slicers to filter the graph so the user can select which combinations they wish to view on the graph.

I would like the legend name to dynamically alter depending upon the following:

If no the Engine slicer has no filter selected then only display Model-Body in the legend (so aggregate the engine type)
If the Body slicer has no filer selected then only display Model in the legend (so aggregate all bodies and all engines)

The current behavior is that if there is no selection in engine then the legend still displays Model-Body-Engine with all possible combinations but no aggregation.

I hope that makes sense to someone

Many thanks for any time spent on this. It's giving me a headache.

mrhopko