Pivot Table Formula

M

Mouimet

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
 

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

Formula in Pivot Table 0
Calculated Field - vLookup 3
Schedule Comparison Error - mismatch duration - "The duration you entered isn't supported for this field. type a duration in the standard format" 0
Doughnut Chart linked with the slicer in the pivot table 0
Selecting Date Range in a Pivot using VBA 0
Slicers and Calculated Items in Pivot Table 2
Pivot table 0
List of Displayed Pivot Items 1

Top