Skip to Content
0
Former Member
Jul 25, 2014 at 09:02 PM

query designer

19 Views

Hello,

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.

etc...

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.

John.