Can anyone help me with a formula or manual:
I want to have this advanced formula in my report (i'm very novice):
of all cars sold, how many red cars are sold which represent over 50% of the total sales of that model.
of all cars sold, how many white cars are sold which represent over 25% of the total sales of that model.
I have the data like in the green section.
the representation of the outcome should be a table like under "analysis"model color Q cars model 1 red 60 white 15 black 25 model 2 red 51 white 26 black 23 analysis red>50% of the model sales 111 white>25% of the model sales 26 black>30% of the model sales 0 black<=30% of the model sales 48
Some guidance, manual, or Bex Formula is really appreciated.