Data deck -> Chart issues with cascading prompts

[Anantula]

Hi All,

I am new to active reports.
I have a requirement to build list, chart with cascading drop down lists. Chart values totals should match with list value.

In my report, chart inside the datadeck is returning the incorrect value and assuming it is because of cascading drop down lists (the result set of chart matching with 1st value of of last prompt selection by default)
I think data deck only works when you set the default prompt values, is it right?
The only time chart returns the right values when I select 3 prompt values. But it should return right value for any of the selection.

Can someone please help me out with this chart fix?  (please refer to sample report spec attachment)

Thank you.

Regards,
Anand