Error creating Pivot Table formula

Topic

New Reply

I get this error message whne I try to create a new pivot table formula: References to multiple item names per field cannot be included in pivot table formulas.

Here’s a screenshot of the pivot table structure and the Insert Calculated Item wizard
33583-PivotTableError

I can’t see why this formula doesn’t work. Any clues?

Reply | Quote

Replies

Sure. I got it.

I must have been asleep at the wheel. I placed items in the Row Labels instead of the Values.

Reply | Quote

Hi

Do not sleep at the wheel.
Take a break.

zeddy

Reply | Quote