Pivot Table in Excel 2007 : Problem with % in Table
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?
|