I have a pivot table with rows, a column dimension, and two measures. As you'd suspect, the rows along one column on the left, the dimension shows at the top of the pivot table dividing the measures into two columns each (there are two options for that dimension) and the measures showing in 4 columns total. I'd like to only have the first measure get divided into the two dimensions listed along the top and the second measure show as a total of the two dimensions resulting in one column.
here's an example of the desired look in a pivot table (not a table)
Thanks!!
| Header 1 | Campus 1 | Campus 2 | Campus 1+2 |
|---|
| thing 1 | Measure 1 | Measure 1 | Measure 2 (total of campus 1 and 2) |
| thing 2 | Measure 1 | Measure 1 | Measure 2 (total of campus 1 and 2) |
| thing 3 | Measure 1 | Measure 1 | Measure 2 (total of campus 1 and 2) |
| | | |