Distribution - Calculated Dimension

[#1]

Hi All,

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.

Any assistance appreciated.

Herbiec

[maxgro · Accepted solution]

maybe in the attachment

[#3]

Perfect Massimo,

Thank you very much, exactly what I needed.

Much appreciated

H