(example)
So if this is my table (turned pie chart)
Color |
# of shirts |
red |
10 |
pale red |
3 |
blue |
5 |
black |
7 |
But in the pie chart, I want Red and Pale red to both be grouped as "red" so the value would be 13 but in a table report, I still want to report them separately in a field.
Is there a way to do this?
Thanks!
------------------------------
Nicole
------------------------------