Pie Chart Report with similar field values
(example)
So if this is my table (turned pie chart)
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
------------------------------
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
------------------------------
