pivot tables and relationships...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a pivot table featuring "names" as rows, "location" and "opponent" as
columns, "wins" as the data, and "region" and/or "weight class" at the top.

my problem is, when i sort the data by weight class, i get lots of gaps
because some of the names are not featured in that weight class. is there a
way i can link th name to the weight class so that when i select certain
weight classes, only certain names' wins are displayed?

thanks much,
stephen
 
Stephen
This is probably a problem with the way your data is
structured. The pivot table should automatically filter
out the blanks. If you want to e-mail me your work I will
try and fix it for you.
Regards,
ID
-----Original Message-----
i have a pivot table featuring "names" as
Click to expand...
rows, "location" and "opponent" as
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table 2
weighted average on a pivot table 2
Erroneous Grand Total of calculated fields in pivot table 2
Pivot Tables with different groupings based on same data table 6
A few problems involving LOOKUP and SUMPRODUCT... 1
Pivot Table Totals 2
Code to add gridlines to Excel Pivot Tables 0
Weighted average in a pivot table 1

Back
Top