Pivot Table/Matrix - Can I use values as a column heading?

Hi, one option you could use is to employ a SWITCH statement with a measures list table to get your measures in your pivot to be shown as you need.  

1. Create a small table with 2 rows - 

Measure                              Order

Application Count               1

Highest Application Count  2

2. Create a Selected Measure  = SELECTEDVALUE([Measure])

3. Create the Switch Statement for the Measures you want to put into the pivot. 

Magic Measure = SWITCH(SelectedMeasure, "Application Count", [Application Count], "Highest Application Count", [Highest Application Count]) 

4. Add the Magic Measure to your Values, 

5. Add the [Measure] Column from your Measures table to the Columns above the Date. 

This is a useful technique to treat measures as column or row headings and gives slightly more flexibility to your pivoting.