Bar Chart problem

[Anonymous]

I'm using QlikView 11.2.

I have loaded a table which has 11 columns:

Currency

Amt1

Amt2

Amt3

....

Amt10

I would like to create a Bar Chart where the X-axis has Amt1... Amt10 and the Y-axis represents SUM() of that Amt.

I also want the user to be able to click on the relevant Currency (eg. AUD, EUR, GBP, JPY) and the chart shows only the SUM() values for that particular Currency.

Is this possible?  If so, could someone please explain how I can go about it?

Kind regards

[sunny_talwar]

Would you be able to provide sample data with expected output?