Bar Chart with several Dimensions

[alec1982]

Hi guys,

I have a table as follow:

Location      Region      Amount

A               America     500

B               America     200

C               APAC        300

D               APAC        150

E               India          200

Assuming that we have a location list box on the dashboard and always one value selected

I need to create a bar chart where the first bar will show the amount of the location and a second bar will show the total amount for the region of that location and a third bar to show the total amount of all locations.

Assuming A is selected on the list boxThe result chart should show the following results:

Location     Region     All

500            700         1350

Please let me know your thoughts..

Thxs,

Alec

[#2 · Accepted solution]

Hi,

    try this attach file.

Regards,

Ashutosh

[#3]

Hi Badr,

Please find attached the .qvw file..

Hope this helps your problem..

FYI, I have taken a bar chart with no dimension but 3 expression as follows:

1. For Location Amount : sum(Amount)

2. For Region Amount : sum({1<Region={$(=Region)}>} total Amount)

3. For Total Amount : sum({<Location=>}total Amount)

And taken Location as a list box with always one selected value..

[#4]

Hi,

PFA

[alec1982]

Thank you guys.. all the solutions are correct