Pivot charts without adding up values

[pmviana]

Hi, i'm trying to build a pivot chart to compare the labour charged vs labour recomended at different models and locations. But at the moment, the pivot chart adds the values of both workshops and models.

Any ideas?

I have a similar table like this:
[TABLE="width: 323"]
<tbody>[TR]
[TD]Location
[/TD]
[TD]Car
[/TD]
[TD]Service
[/TD]
[TD]Labour
[/TD]
[TD]Labour Ref.
[/TD]
[/TR]
[TR]
[TD]London
[/TD]
[TD]BMW 520
[/TD]
[TD]10000
[/TD]
[TD]5
[/TD]
[TD]4
[/TD]
[/TR]
[TR]
[TD]London
[/TD]
[TD]BMW 330
[/TD]
[TD]10000
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]London
[/TD]
[TD]BMW 630
[/TD]
[TD]10000
[/TD]
[TD]8
[/TD]
[TD]5
[/TD]
[/TR]
[TR]
[TD]Manchester
[/TD]
[TD]BMW 520
[/TD]
[TD]10000
[/TD]
[TD]6
[/TD]
[TD]4
[/TD]
[/TR]
[TR]
[TD]Manchester
[/TD]
[TD]BMW 330
[/TD]
[TD]10000
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]Manchester
[/TD]
[TD]BMW 630
[/TD]
[TD]10000
[/TD]
[TD]7
[/TD]
[TD]5
[/TD]
[/TR]
[TR]
[TD]Brighton
[/TD]
[TD]BMW 520
[/TD]
[TD]10000
[/TD]
[TD]5
[/TD]
[TD]4
[/TD]
[/TR]
[TR]
[TD]Brighton
[/TD]
[TD]BMW 330
[/TD]
[TD]10000
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]Brighton
[/TD]
[TD]BMW 630
[/TD]
[TD]10000
[/TD]
[TD]6
[/TD]
[TD]5

[/TD]
[/TR]
</tbody>[/TABLE]

 

[Pup Denab]

<colgroup><col style="mso-width-source:userset;mso-width-alt:3328; width:68pt" span="2" width="91"> <col style="mso-width-source:userset;mso-width-alt:3620;width:74pt" width="99"> <col style="mso-width-source:userset;mso-width-alt:3510;width:72pt" width="96"> <col style="mso-width-source:userset;mso-width-alt:4571;width:94pt" width="125"> </colgroup><tbody>
[TD="class: xl63, width: 91"][/TD]
[TD="class: xl63, width: 91"][/TD]
[TD="class: xl63, width: 99"]Values[/TD]
[TD="class: xl63, width: 96"][/TD]
[TD="class: xl63, width: 125"][/TD]

[TD="class: xl63"]Car[/TD]
[TD="class: xl63"]Location[/TD]
[TD="class: xl63"]Sum of Service[/TD]
[TD="class: xl63"]Sum of Labour[/TD]
[TD="class: xl63"]Sum of Labour Ref.[/TD]

[TD="class: xl63"]BMW 330[/TD]
[TD="class: xl63"]Brighton[/TD]
[TD="class: xl63"]10000[/TD]
[TD="class: xl63"]1[/TD]
[TD="class: xl63"]2
[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63"]Manchester[/TD]
[TD="class: xl63"]10000[/TD]
[TD="class: xl63"]2[/TD]
[TD="class: xl63"]2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63"]London[/TD]
[TD="class: xl63"]10000[/TD]
[TD="class: xl63"]3[/TD]
[TD="class: xl63"]2[/TD]

[TD="class: xl63"]BMW 520[/TD]
[TD="class: xl63"]London[/TD]
[TD="class: xl63"]10000[/TD]
[TD="class: xl63"]5[/TD]
[TD="class: xl63"]4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63"]Brighton[/TD]
[TD="class: xl63"]10000[/TD]
[TD="class: xl63"]5[/TD]
[TD="class: xl63"]4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63"]Manchester[/TD]
[TD="class: xl63"]10000[/TD]
[TD="class: xl63"]6[/TD]
[TD="class: xl63"]4[/TD]

[TD="class: xl63"]BMW 630[/TD]
[TD="class: xl63"]Brighton[/TD]
[TD="class: xl63"]10000[/TD]
[TD="class: xl63"]6[/TD]
[TD="class: xl63"]5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63"]Manchester[/TD]
[TD="class: xl63"]10000[/TD]
[TD="class: xl63"]7[/TD]
[TD="class: xl63"]5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63"]London[/TD]
[TD="class: xl63"]10000[/TD]
[TD="class: xl63"]8[/TD]
[TD="class: xl63"]5[/TD]

</tbody>

HI pmviana
Welcome to the forum, I think you just need to put the car and location in the row labels, as above, is that what you would like to see
Reagrds
Pup

 

[pmviana]

<tbody>
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63, width: 99"]Values
[/TD]
[TD="class: xl63, width: 96"][/TD]
[TD="class: xl63, width: 125"][/TD]

[TD="class: xl63"]Car
[/TD]
[TD="class: xl63"]Location
[/TD]
[TD="class: xl63"]Sum of Service
[/TD]
[TD="class: xl63"]Sum of Labour
[/TD]
[TD="class: xl63"]Sum of Labour Ref.
[/TD]

[TD="class: xl63"]BMW 330
[/TD]
[TD="class: xl63"]Brighton
[/TD]
[TD="class: xl63"]10000
[/TD]
[TD="class: xl63"]1
[/TD]
[TD="class: xl63"]2
[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63"]Manchester
[/TD]
[TD="class: xl63"]10000
[/TD]
[TD="class: xl63"]2
[/TD]
[TD="class: xl63"]2
[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63"]London
[/TD]
[TD="class: xl63"]10000
[/TD]
[TD="class: xl63"]3
[/TD]
[TD="class: xl63"]2
[/TD]

[TD="class: xl63"]BMW 520
[/TD]
[TD="class: xl63"]London
[/TD]
[TD="class: xl63"]10000
[/TD]
[TD="class: xl63"]5
[/TD]
[TD="class: xl63"]4
[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63"]Brighton
[/TD]
[TD="class: xl63"]10000
[/TD]
[TD="class: xl63"]5
[/TD]
[TD="class: xl63"]4
[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63"]Manchester
[/TD]
[TD="class: xl63"]10000
[/TD]
[TD="class: xl63"]6
[/TD]
[TD="class: xl63"]4
[/TD]

[TD="class: xl63"]BMW 630
[/TD]
[TD="class: xl63"]Brighton
[/TD]
[TD="class: xl63"]10000
[/TD]
[TD="class: xl63"]6
[/TD]
[TD="class: xl63"]5
[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63"]Manchester
[/TD]
[TD="class: xl63"]10000
[/TD]
[TD="class: xl63"]7
[/TD]
[TD="class: xl63"]5
[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63"]London
[/TD]
[TD="class: xl63"]10000
[/TD]
[TD="class: xl63"]8
[/TD]
[TD="class: xl63"]5
[/TD]

</tbody>

HI pmviana
Welcome to the forum, I think you just need to put the car and location in the row labels, as above, is that what you would like to see
Reagrds
Pup

Hi Pup, thanks for the welcome.

I missed some info. As i have specific recommended labour hours for each model (this is nothing related to BMW, it is just an example), and i want to compare those to each location and model.
[TABLE="width: 660"]
<tbody>[TR]
[TD]MODEL
[/TD]
[TD]SERVICE
[/TD]
[TD]LABOUR REF
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BMW 520
[/TD]
[TD]10000
[/TD]
[TD]4
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BMW 330
[/TD]
[TD]10000
[/TD]
[TD]2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BMW 630
[/TD]
[TD]10000
[/TD]
[TD]5
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Car
[/TD]
[TD]VIN Nr.
[/TD]
[TD]Location
[/TD]
[TD]Service
[/TD]
[TD]Labour
[/TD]
[TD]Labour Ref.
[/TD]
[/TR]
[TR]
[TD]BMW 330
[/TD]
[TD]1234214
[/TD]
[TD]London
[/TD]
[TD]10000
[/TD]
[TD]2,5
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]BMW 330
[/TD]
[TD]565467
[/TD]
[TD]London
[/TD]
[TD]10000
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]BMW 330
[/TD]
[TD]8764353
[/TD]
[TD]Manchester
[/TD]
[TD]10000
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]BMW 330
[/TD]
[TD]658906
[/TD]
[TD]Brighton
[/TD]
[TD]10000
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]BMW 330
[/TD]
[TD]53875632
[/TD]
[TD]Brighton
[/TD]
[TD]10000
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]BMW 520
[/TD]
[TD]8679763
[/TD]
[TD]London
[/TD]
[TD]10000
[/TD]
[TD]5
[/TD]
[TD]4
[/TD]
[/TR]
[TR]
[TD]BMW 520
[/TD]
[TD]867574536
[/TD]
[TD]London
[/TD]
[TD]10000
[/TD]
[TD]4
[/TD]
[TD]4
[/TD]
[/TR]
[TR]
[TD]BMW 520
[/TD]
[TD]547853
[/TD]
[TD]London
[/TD]
[TD]10000
[/TD]
[TD]5,5
[/TD]
[TD]4
[/TD]
[/TR]
[TR]
[TD]BMW 520
[/TD]
[TD]5676532
[/TD]
[TD]Manchester
[/TD]
[TD]10000
[/TD]
[TD]5
[/TD]
[TD]4
[/TD]
[/TR]
[TR]
[TD]BMW 520
[/TD]
[TD]8652465
[/TD]
[TD]Manchester
[/TD]
[TD]10000
[/TD]
[TD]6
[/TD]
[TD]4
[/TD]
[/TR]
[TR]
[TD]BMW 520
[/TD]
[TD]54642576
[/TD]
[TD]Brighton
[/TD]
[TD]10000
[/TD]
[TD]5,5
[/TD]
[TD]4
[/TD]
[/TR]
[TR]
[TD]BMW 520
[/TD]
[TD]34675625
[/TD]
[TD]Brighton
[/TD]
[TD]10000
[/TD]
[TD]5
[/TD]
[TD]4
[/TD]
[/TR]
[TR]
[TD]BMW 630
[/TD]
[TD]2557234
[/TD]
[TD]London
[/TD]
[TD]10000
[/TD]
[TD]8
[/TD]
[TD]5
[/TD]
[/TR]
[TR]
[TD]BMW 630
[/TD]
[TD]6542353
[/TD]
[TD]Manchester
[/TD]
[TD]10000
[/TD]
[TD]7,5
[/TD]
[TD]5
[/TD]
[/TR]
[TR]
[TD]BMW 630
[/TD]
[TD]3456435
[/TD]
[TD]Manchester
[/TD]
[TD]10000
[/TD]
[TD]5
[/TD]
[TD]5
[/TD]
[/TR]
[TR]
[TD]BMW 630
[/TD]
[TD]123435
[/TD]
[TD]Manchester
[/TD]
[TD]10000
[/TD]
[TD]7
[/TD]
[TD]5
[/TD]
[/TR]
[TR]
[TD]BMW 630
[/TD]
[TD]7868764
[/TD]
[TD]Brighton
[/TD]
[TD]10000
[/TD]
[TD]5
[/TD]
[TD]5
[/TD]
[/TR]
[TR]
[TD]BMW 630
[/TD]
[TD]765325
[/TD]
[TD]Brighton
[/TD]
[TD]10000
[/TD]
[TD]6
[/TD]
[TD]5
[/TD]
[/TR]
</tbody>[/TABLE]

And when i do a pivot chart, it will add all the labour hours of the same model and the labour reference. And what i really want is something where i can choose the model and compare the labour reference against the real hours charged in the three sites for a specific service.

Many thanks!

 

[Pup Denab]

HI pmviana
I think I understand now, what you want from you example is the actual hours compared with the recommend hours, now what would you like to see the top over hour from each location and or the under hours from each location, as it seems to me, that you have a large data set
Regards
Pup