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개
You need to pivot your measures and use pivot field names on color and pivot field values on Columns.
