Hello all,
I have 7 value fields for hours by ethnicity, and a field for total hours.
I can get them to display as a bar chart, but it's not exactly what I want. I want to display the Total Hours bar as a stacked bar chart, divided up with color by each of the 7 fields.
I think I need to create some sort of dimension field for the 7 values, but I'm not sure how to go about it.
Packaged workbook attached. Can anyone point me in the right direction?
2 answers
You need to pivot your measures and use pivot field names on color and pivot field values on Columns.
