Pivot Chart not reflecting data correctly

499 Views Asked by At

I am a bit new to Pivot charts but I am trying to build a dual axis chart that shows the total purchase order Count and the Average age of purchase orders. I have posted a screen grab of the chart. The PO count is changing over the dates as I would expect it to but the average age isn't - it is staying flat - even though the data has changed (it is calculated field if that helps (age/total PO). The odd thing is when I click on the slicer for an employee or manager name, the age does change. Not sure if I am missing something basic. Thanksenter image description here

0

There are 0 best solutions below