I am trying to create a distribution graph that shows the number (distinct) of clients with a certain Average $/Kg, eg number of farmers between 2.0 and 2.5, farmers between 2.5 and 3.0 etc. I have attached a spreadsheet with some dummy data. I am not sure about the scripting for the calculated dimension. Average $/Kg is Value($)/Kgs. Please also note that each client may have more than one transaction.
