Pivot Table data

[ahern79]

I'm not sure if this is the correct forum for this but here goes.

I have a pivot table that draws from several pages. when I click on the
values to find out what makes the values I get a second sheet that has:

ROW Column Value Page1
Item number Cumber title a date Item3 (or Item1, or
Item2...you get the idea)

How do I change the "Item#" to the actual sheet it came from.

if I need to explain more please let me know.
Thank you

 

[Herbert Seidenberg]

When you create the Pivot Table,
in step 2A of the Pivot Table Wizard, select
"I will create the page fields"
In step 2B, select the individual ranges and
enter in "Field one" the associated sheet name.
See:
http://www.savefile.com/files/1685275