HAHA!

I figured it out.

=IF(AND(H$17=H$27,$A28=$A18),H18,IF(AND(G$17=H$27, $A28=$A18),G18,IF(AND(F$17=H$27,$A28=$A18),F18,IF( AND(E$17=H$27,$A28=$A18),E18,IF(AND(D$17=H$27,$A28 =$A18),D18,IF(AND(C$17=H$27,$A28=$A18),C18,IF(AND( B$17=H$27,$A28=$A18),B18,"0")))))))

If you know a better way, please tell me.

"Schwimms" wrote:

Roger,

Awesome! But, I still have a problem.. those dates are every day in the
year. When I click the entry to show items with no data, it shows an excess
of 360 days. I have a filter in the page that allows me to only show the
previous week. Any idea on what to do to get just the previous weeks data in
my pivot??

"Roger Govier" wrote:

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