How to add two rows in a pivot table?

[nishanthi_8]

Hi I have attached a sample snapshot where  I have to add the two rows values of hierarchy level 00 and 01 and 05  and 06. How to do so?

so that I will be sorting my data like

00-01

02

03

04

05-06

[Chanty4u]

chk dis

Add Rows on Pivot Tables

very very important....how to add a row in pivot table

[sunny_talwar]

Use a calculated dimension;

If(Match(HierarchyLevel, '00', '01', Dual('00-01', 0),

If(Match(HierarchyLevel, '05', '06', Dual('05-06', 1000), HierarchyLevel))