Hi, guys,

I have a pivot table with counts by month of H, L, & U.
(high, low, or unchanged days in a stock index.)

Change over Prior Day (count by month)
H L U
Date ...
Feb 17 ... 15 4 -
Jan 17 ... 9 10 1
Dec 16 ... 12 9

I want a new calculated field showing percentages.

H / L
or maybe ( H + U ) / L
or maybe H / ( L + U )

(I have to think about the formula some more, as to what
will be most useful.)

Anyway, how do I put this sort of calculated field into
my pivot? I know how to insert a calculated field. I
don't know what formula I would use for this.
Help appreciated.

Cheers,
/sarah