0

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

user3496218
  • 185
  • 3
  • 5
  • 19
  • What data is not reflected correctly? What does the pivot table show? If the results of the calculated field are not what you expect, then the calculated field does not perform correctly. The chart just plots the numbers from the pivot table. Tackle the numbers. – teylyn Dec 18 '17 at 01:01
  • will try to post some of the actual data – user3496218 Dec 18 '17 at 02:19
  • the issue is that the average age is different on 12/14, 12/20 & 12/27 - it just stays at the number from 12/14 and I can't figure out why when the primary axis is updating from the updates as I would expect – user3496218 Dec 18 '17 at 02:20
  • Is the pivot table showing the correct numbers? If not, don't blame the chart. You need to change the formula for the calculated field. You probably will need power pivot to calculate what you want, or a helper column in your source data. – teylyn Dec 18 '17 at 07:57

0 Answers0