Calc Field not showing on New Sum Row in Pivot table

M

MacGuy

I have a pivot table that has several column fields and 2 data columns with a
calculated data field variance (data col1 - data col 2). There are also
several page fields that remain untouched.

When I take out a sum subtotal for a column field and add it back, I
recreate the same calculated field (delete the current one and create new
calc field) it works for every row but not for any sum subtotal that was
removed and then put back.

Any ideas?
 

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

Top