I've got a hierarchy which drills from Region (East/West) to Store (Multiple per region).
I've setup a line chart which displays Sales for each region; I've done this by adding Region to the Color area.
Is it possible to display the two data series for East/West then drill down to Store and have it display the Store level data series? I.e. Go from the two lines (East/West) to many lines (one for each store) ?