• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 192
  • Last Modified:

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
0
Marcia Morris
Asked:
Marcia Morris
  • 3
  • 2
1 Solution
 
Rgonzo1971Commented:
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
0
 
Marcia MorrisProject ManagerAuthor 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?
0
 
Rgonzo1971Commented:
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
0
 
Marcia MorrisProject ManagerAuthor 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?
0
 
Rgonzo1971Commented:
No,

Sorry
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now