I am looking to create a simple list of values, both measures and dimensions, filtering by a "School" dimension. So when a school is selected, it will display the Measure Names and Dimension Names in a column, and the values in the next column. Is there a way to do this? I know I can do this with only measures, using the Measure Names and Measure Values in the rows/columns, but I'd like some categorical information in there as well. Any help is appreciated! See my ideal format below.
To make sure I'm understanding this right, you want the capability of Measure Names in addition to only the Dimensions names on the view (along with measure values) and not the actual dimension members?