Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Currently, I have Review Is Needed as a Dimension, but I would like the headers to be the Review Needed results and group them as the second picture.
Current View
Desired View
I would suggest you to read @hic old blog post about The Generic Load in order to solve your issue.
you could try Adding a column in the data, something like:
'Review Needed' as "Review Category"
This will give you the same dimension value for every record, then you can use the existing field as the second layer in the pivot table.
Added screenshots on top of @jheasley post:
Output:
Chart Properties:
Add in measure after adding your 'Review Needed' as Column.
Much appreciated worked well.