pivot table calculations

[Guest]

how do i modify how a pivot table calculates my data? i would like to have
they Grand Totals to use the =SUM(COUNTIF(E10:E15,"1")) & " / "
&SUM(COUNTIF(E9:E15,"0")) formula, but it only sums and counts. not both.
how do i get it to calulate the totals according to that formula?

thanks much,
stephen

 

[Frank Kabel]

Hi
AFAIK you can't add such formulas to a pivot table

 

[Myrna Larson]

You can add formulas below or to the right of the pivot table.