3 of 3 people found this helpful
There were two measures in your data file, I used the Addressed measure:
To build the view, once I put KPI on the Rows Shelf I dragged Addressed from the Measures window to the Text shelf. This automatically applies the SUM() aggregation. Then I clicked on the SUM(Addressed) pill on the Text Shelf and changed it to Percentile25:
Then I dragged another instance of the Addressed field onto the data area and dropped it when the display said "Show Me:
This creates a Measure Names/Values crosstab with the PCT25(Addressed) and SUM(Addressed) pills in the Measure Values Shelf. I could then change the SUM(Addressed) to PCT75(Addressed).
That takes 8 mouse clicks (including rearranging the pills on Measure Values to sort them). The next step would be to right-click on each column label and change the alias as desired. Sample workbook is attached.
Thank you very much Jonathan! This is a much simpler route than what I was exploring.
Just wanted to say thanks to Jonathan for detailing the steps he took to get to the final solution. Sometimes it can be a bit hard to work out what people have done when they only post the solution as a workbook (especially when there are more steps than in this example). Big thumbs up.