Pivot Table in Excel 2007 : Problem with % in Table

  • Thread starter Thread starter spudsnruf
  • Start date Start date
S

spudsnruf

Hello,
in My Pivot table, I have rows as PRODUCT TYPEs and my columns as RETAILERS.
When I drag the field of % sales into the data area, it just comes as a lot
of 1's and 2's rather than the actual % sales figure that it needs to be, and
that it is in the original table that the pivot table is built up from. I


I've tried changing the VALUE FIELD SETTINGS to a different value, but
nothing actually give sme the %sales figs that I need.

Any help please?
 
Hello,

If your table is setup as such:

prod_id retailer percent
a 1 0.33
b 2 0.33
c 3 0.34

When you pull the percent into the data portion of the pivot, right click
where it is probably saying "count of %" and change that to sum. That should
give you the percent.

HTH
Roger
 

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 Data Column Sort Excel 2007 1
Value filter missing in pivot table 3
Problem inserting calculated pivot fields into Pivot Table (2007) 1
Pivot Table Help 1
Rank items in Pivot Table 3
Display No Data in Pivot 1
Rank in Pivot Table 3
Pivot Table Data 2

Back
Top