First of all I am a beginner.
Let say that we have a table with 6 fields : Customer, customer familly, ,order number, year, Sales, gross margin
The goal is to produced a bubble chart having as axis : Turnover increase rate (Selected year versus the year before), gross margin rate (gross margin / sales)
The bubble should represent the gross margin value., for a given customer
The chart should change if a customer familly is selected or changed
I have struggled a little bit with nested agreagation (aggr), and must adminted that i could make it work.
Must be classic and stupid
Many thanks in advance.