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) ?
try a calculated field like this on the Color shelf:
IF MAX([Store])=MIN([Store]) THEN [Store] ELSE [Region] END
if that does not work, please provide a packaged workbook that represents your situation.