How to eliminate % totals in a Pivot Table

[Doria/Warris]

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

 

[radiation_rat]

hide your present ActualVsBudget% column, and go to pivot table toolbar,
select under Pivot Table menu->Formulas->Calculated field, and create
formula for % column.
Other ultra-mega-turbo-simple way, just flash me (if i'm not mis something)
is just to set font colour in %total column to white (or background colour).