how to find contribution ?

[msbhuvanesh003]

Dear Experts,

I want to find out the contributions of particular bank transaction.

I have more than 150 bank from various countries.

When I select one bank from the filter pane the pie chart will shows transaction contribution of the bank and rest bank transaction for the country.

Could you please share the expression for the calculation for build the pie chart.

I have attached the requirement for your reference.

Kindly share the calculation expression ASAP.

Sample Result:

[sunny_talwar]

May be using two expressions

1) Sum(Transactions)

2) Sum({<Bank>} Transactions) - Sum(Transactions)

[shiveshsingh]

You can get idea from attached app

[Peter_Cammaert · Accepted solution]

Maybe not the most elegant solution but it works. It works even for multiple selections vs. the others.

[msbhuvanesh003]

Dear Shivesh,

I tried this also but not working.

any other expressions available.

[msbhuvanesh003]

Sorry Sunny

[msbhuvanesh003]

Dear All

please help me for find out the solution for this requirement.

[Peter_Cammaert]

Did you try the above example?

[msbhuvanesh003]

Dear Peter

I tried many times but pie chart not showing the result.

[Peter_Cammaert]

Well, it does for me:

Care to post one of your attempts, so that we can have a look at your object and expressions?