Dynamic Histogram showing total earnings for each simulation

[Anonymous]

Hi all, 
I`m trying to create a dynamic/filterable histogram that shows:
x-axis: sum of earnings per simulation number
y-axis: Number of simulations in each bucket (Distinct Count of Simulation Number)
Filters: a. Asset Scenario & b. FY

Using the following data:

FY	Asset Scenarios	Earnings values	Simulation Number
22	23	0.830882	1
22	23	0.780357	2
22	23	0.692215	3
22	23	0.398168	4
22	23	0.99823	5
23	22	0.930938	1
23	22	0.32492	2
23	22	0.61862	3
23	22	0.790725	4
23	22	0.223686	5
23	23	0.240326	1
23	23	0.255442	2
23	23	0.902836	3
23	23	0.053757	4
23	23	0.798733	5
22	22	0.820999	1
22	22	0.973459	2
22	22	0.964044	3
22	22	0.225193	4
22	22	0.3573	5

[lbendlin]

This is not a histogram but it is dynamic. For a histogram you'll have to change the sort order as needed

see attached.