Pivot table with Calculated Item with Two Rows Label

Hi all,

I have a data like...
Group Sub Group Year Sales
Braking Pads 2015 10
Braking Disc 2015 23
Braking Calliper 2015 54
Fliters Air 2015 60
Fliters Oil 2015 432
Fliters Pollen 2015 76
Fliters Fuel 2015 30
Braking Pads 2016 20
Braking Disc 2016 32
Braking Calliper 2016 45
Fliters Air 2016 76
Fliters Oil 2016 120
Fliters Pollen 2016 34
Fliters Fuel 2016 56

Now turning data in to pivot table and using calculate Item to get variance between two year, showing sub group which not relate to the group

For Example:
In Group "Braking" showing subgroup Air, Fuel, Oil, and Pollen (Which is wrong)

Is there any way that Ii can see variance by year with group and sub group in pivot table.

See attached file for more explanation.

Thanks
Vinay

Hi,

I have slightly re-arranged you Pivot Table which I believe will give you what you are after - please see attached.
(please note the row total is adding the variance figure to the yearly figures which is obviously wrong)
Will this work for you?

Regards

peterrc