- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel
- 2004 May
- How to eliminate % totals in a Pivot Table

Subject: | How to eliminate % totals in a Pivot Table |

Posted by: | Doria/Warris (doriaw…@pandora.be) |

Date: | Sat, 8 May 2004 |

Hi,

In my Pivot Table, I have a field in the Column part which contains

different items (from a DB).

I try to simplify with an example: 3 months containing volume data measured

in Tons (3 columns), then different additional columns measuring the Actual

Vs budget in %

All the % are calculated automatically into the source DB, so no calculation

is made in the pivot.

The issue is that in the Subtotals and Totals I get the sum for the volumes

of every month, which is fine, but I also get the sum of the % Vs budget,

which of course is not a good thing. So, I end up to have:

FIELD

Jan Feb March Actual Vs Budget

10 5 15 98%

10 20 30 90 %

---------------------------- -----------------------------

20 25 45 188%

To my knowledge, I can only format the Sub or Totals per FIELD and not per

single item.

How can I eliminate or hide the % summing up (188 in my example?)

I was thinking to conditional formatting, but I cannot say when Cell X is

showing "Hide it", because the cells where the totals appear change every

month.

If you think the only solution I have is to let the pivot table calculate

the Actual Vs Budget, resulting in adding another FIELD, please, let me know

where I should look at to enter the formula.

Thanks for any help

Alex

- Re: How to eliminate % totals in a Pivot Table posted by Debra Dalgleish on Sun, 09 May 2004