Hi

Double click on your Row field header in the PTselect Include Items with no
data
Your tables will now be identical in layout.
--
Regards
Roger Govier



"Schwimms" wrote in message
...
Hello,

I have a pivot that changes when you select a certain criteria in the
pivot,
meaning sometimes there will be some rows and columns that are the
disapear.

Then I have a standardized table, that always has the same data. I want to
be able to pull the values within the pivot to match the correlating
standard
data.

pivot example:
Date 1 Date 2 Date 4 Date 6
A 1
B 3
D 2 4
F 4 2

standard table:
Date 1 Date 2 Date 3 Date 4 Date 5 Date 6 Date 7
A 1
B 3
C
D 2 4
E
F 4 2