We help IT Professionals succeed at work.

My Pivot table isn't pulling the quanities?

Hello! It's me again with the same spreadsheet.

1. The order quantity tab isn't showing the correct numbers for February FP/RP. The quantities should be FP 15 & RP 132 but it shows 6 for RP only.

2. Also, right now I am inserting a text box on the actual chart and manually inputting the quantities. Is there a way to make this not a manual process? What happens is when I update the data I have to remember to go to the actual chart and update the quantities (I use the order quantity tab so that I don't have to filter & count it from the source data).

3. I would like to add the the PO delay reason (column F) as a secondary chart/pivot and wanted to get some recommendations on how I should display that data. I was thinking maybe just a pie chart? But not sure....thoughts?

Thanks in advance!
Marcia
Order-Tracking-Matrix-022615.xlsm
Comment
Watch Question

Top Expert 2016
Commented:
HI,

your Data source is only until line 537 not 679 like your data

you could create a named range with this formula

=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),13) to use as source

Regards
Marcia MorrisSr. Project Manager

Author

Commented:
Rgonzo1971, what does this formula mean?

Also, I updated the range in the data sheet. Is the formula you are suggesting I use will eliminate this issues of having to check to make sure my pivot is capturing all the fields?
Top Expert 2016

Commented:
I see that you already have myTable named range as the right formula

pls replace your data source with myTable

and your Pivot should have all the data

Regards
Marcia MorrisSr. Project Manager

Author

Commented:
Rgonzo1971...I replaced it with your data source. Thank u.

Do you have any thoughts /suggestions on how I should display the PO delay reasons?
Top Expert 2016

Commented:
No,

Sorry