Pay Rate error in pivot table with a date filter

theYaniac

Board Regular
Joined
Jan 7, 2018
Messages
56
Office Version
  1. 365
Platform
  1. Windows
I have a pivot table built for tracking weekly data. I have a filter in it for job numbers and week ending dates. When the date filter is set to the first set of data (earliest week ending date in the source data) the pay rates show up like expected. When I change the filter to the next week ending date the pay rate returns an #N/A error. I am struggling to figure out why the pay rate is not showing up for the later dates. Below are some screen shots of the table
1659123137053.png


1659123204478.png


Wondering if I am missing something in the pivot table settings somewhere. Any help would be greatly appreciated.
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

theYaniac

Board Regular
Joined
Jan 7, 2018
Messages
56
Office Version
  1. 365
Platform
  1. Windows
I figured it out. I apoligze for the silly question. I had soem fo the information incorrectly formatted. It's been a very long week.
 
Solution

Forum statistics

Threads
1,181,057
Messages
5,927,876
Members
436,574
Latest member
Bosniain

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top