G
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
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