How did you do that?
I see you moved Measure Names to columns, then ... what
1 of 1 people found this helpful
First, I removed all of your pills from the detail shelf and filter shelf, so I had a blank slate, except for your rows and columns pills.
Then, I tried a few things that didn't work. Usually, if you drag more than one measure onto the canvas, it automatically switches to measure names/measure values mode. In your situation, it put one of them on text and the other on color, which I didn't expect. I'm guessing that is because you had put that item on color before, so it defaulted to that.
That caused me to use the manual method for measure names/measure values:
- Drag Measure Values onto Text
- Drag Measure Names onto Columns, after Number In Cohort
- That gets very close, but the Sem% is summed, which you don't want. Since ATTR(Sem%) worked for you before, you have several solutions that all work the same by changing the Sum(Sem%) pill to:
(The secret to the last step is that ATTR() compares the min and max values, and if they are equal, displays the value. If not, it displays *. If the min and max are equal, then all the values are the same, so min, max, average and median are all the same values.)
I hope that helps!
Oh, and I forgot to say a big THANK YOU for including a sample packaged workbook! It made it much easier to help you.