Linking labels in a pivot table

W

WVAE

I making a pivot table where I would like to display sales figures of our
sales people. I would like to display their name as well as the number of
their sales district (both name and sales district number is in the original
data file). How can I link these two labels so I wont get all the data
displayed twice?

Thanks in advance
 
A

Ashish Mathur

Hi,

I am not very clear about your question. Anyways, try this. Drag name and
sales district number to the row area and then drag sales figures to the
data area.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 

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 Calculated Field 0
How to ignore a column of numbers in Grand Total for rows 1
Changing Pivot Table Value Field Labels with VBA 0
Doughnut Chart linked with the slicer in the pivot table 0
combine column labels in pivot table 3
Apply Filter to source of Pivot Table 2
Pivot Table Hiding Totals = Zero 0
Pricing Analysis a bit convoluted 3

Top