Need to drill down data by using pivot table!

[senthilgjs]

Hi-

i have a report having following columns using excel 2007-

[pre]

Requestname	trackname	buildmonth	branch	kins build time
kins -aab	aad	4	2013.4.13	4.5
kins -aab	aad	6	2013.11.13	5.6
kins -aab	aad	3	2013.17.13	4.3
average aad				        4.8
kins -abb	vippe	4	2013.4.13	4.5
kins -abb	vippe	6	2013.11.13	5.6
kins -abb	vippe	3	2013.17.13	4.3
average vippe				        4.8

[/pre]
here i need to display only average aad/vippe rows,here clicking upon i would like to display the individual rows using pivot table

 

[bobhc]

Good day senthilgjs


Post edited with back ticks


Do you need to use a PT, this could be done very easily in with table filtering?

 

[Hui]

If you make a PT

Double clicking any value or total shows which records made that value in a new Worksheet