G
Guest
i have a pivot table where i display who won a wrestling match along with
when and where.
the problem is, i want two things that i'm not sure are possible:
1) in the totals and subtotals, i would like to have them display the number
of times my data says "won" or "1" then a "/" and the number of times my data
says "lost" or "0".
i also have a "won by fall" column that features a "1" or a "0", indicating
whether they won by fall or not, but i also have a "forfeight" in some.
2) i need it to return the word "forfeight" in the cell corresponding to
that in the pivot table, but not count it in the totals and subtotals.
thanks much,
stephen
when and where.
the problem is, i want two things that i'm not sure are possible:
1) in the totals and subtotals, i would like to have them display the number
of times my data says "won" or "1" then a "/" and the number of times my data
says "lost" or "0".
i also have a "won by fall" column that features a "1" or a "0", indicating
whether they won by fall or not, but i also have a "forfeight" in some.
2) i need it to return the word "forfeight" in the cell corresponding to
that in the pivot table, but not count it in the totals and subtotals.
thanks much,
stephen