View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mouimet Mouimet is offline
external usenet poster
 
Posts: 41
Default Pivot Table Formula

Hi,
Does someone can help on this please.
In the same field I have 4 different Items (4 columns in the Pivot table)
SalesA, SalesB, Refusal, Pending
I need to add SalesA with SalesB
I tried the Formulas "Calculated Item", however I get a message:
Multiple data fields of the same field are not supported when a Pivot table
report has calculated Items.
How can I fix that.
Thanks