To show a static total in a chart

[josephinetedesc]

hi

what I want is to allow users to select car type = Fords, but the total not to change ie to be static at 52 for example for the month of Jan.  At present I can get the total but if the users select Fords -it shows the Fords total, I want to see the Fords total in relation to the Total of all cars sold.

Thank you

Jo

Month	1/01/2015	1/02/2015	1/03/2015	1/04/2015
Fords	30	40	30	40
Holdens	20	30	20	30
Kias	2	5	6	4
total	52	75	56	74

[MK_QSL]

Where is Month/Date fields? What result you are expecting?

Check enclosed file. Is this what you are looking for?

[fred_s]

Hi Josephine,

I believe the Gauge does exactly what you want to achieve:

..how well each carmake is performing against the total of all cars sold..

[josephinetedesc]

I ended up using

Sum({$<CarMake={'Fords','Holdens','Kias'}>}NumSold)

the best tutorial ever was by Michael Tarallo:

https://www.youtube.com/watch?v=YMQJnKMkfxg

https://www.youtube.com/watch?t=171&v=nB-HJ8X1QbI

Jo