PIVOTTABLE: Calculated item causes incorrect row label.

CANAPONE,

I know I can do that in a separate column, but every time new data is added or the layout of the PivotTable changes, I will have to adjust the column accordingly. Unfortunately, that's not very practical, but thanks for your suggestion. It looks like Calculated Items are a pain in the *ss.

Originally Posted by JosephP

it's not a bug as such-just an annoying feature. add a new column to the table that makes your From values negative then simply add row totals-see attached file

From what i can see in your example, adding a column with negative numbers will help avoid using Calculated items. This works, but I thought a PivotTable would handle this just fine without having to change the source data. I guess I was wrong.

JP, are you aware of why Calculated Items present the data the way they do? Is there a particular reason they work differently from standard PivotTable items?

Thanks.