Pivot Table - Blank SubTotal in Calculated Field

G

Guilk

Hello,

I looked around without success.

In a Pivot table, there are 2 existing fields, linked to a spreadsheet, 'N'
and 'N-1' for items split in 2 groups.
I created a Calculated Field "Y/Y"= 'N'/'N-1'-1 to simply get the variation
between the 2 years.

N N-1 Y/Y
Group 1 a b %
c d %
Total Group 1 U V
Group 2 e f %
g h %
i j %
Total Group 2 W X
Grand Total Y Z %

The Y/Y results are corrects for each items and the "Grand Total".
The problem is that nothing appears for the Subtotal Y/Y variation.

Could you help?

I use Excel 2000. Tks a lot.
 

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