N
Neil G
I recently had a problem with values not showing properly in my PivotTable,
until it was poited out to me that I was using Text in some cells instead of
numbers.
Ideally, I would like to include text. Is there anyway at all that I can?
My data comes from an Access Table by the way
My reasoning.
the data in the pivot shows scores overall of several years competition, and
each meet has 2 reserves, who can step in for an excluded competitor.
However, the reserves might not compete, but still need to be recorded as a
competitor at the event.
Rather than showing zero (0) as their score, I'd rather use DNR (Did not
ride)
I think my biggest problem here is that the data in Access needs to be a
number field, other wise the pivot only shows a 1 or a 0
Thoughts?
Neil
until it was poited out to me that I was using Text in some cells instead of
numbers.
Ideally, I would like to include text. Is there anyway at all that I can?
My data comes from an Access Table by the way
My reasoning.
the data in the pivot shows scores overall of several years competition, and
each meet has 2 reserves, who can step in for an excluded competitor.
However, the reserves might not compete, but still need to be recorded as a
competitor at the event.
Rather than showing zero (0) as their score, I'd rather use DNR (Did not
ride)
I think my biggest problem here is that the data in Access needs to be a
number field, other wise the pivot only shows a 1 or a 0
Thoughts?
Neil