PowerPivot Slicer Help (not sure if this is possible...)

[jcwynes]

I work for a debt collection company and am building a new all inclusive report.

What I'd like is only two columns; (1) the employee's name and (2) a measure column. I have about 20 measures of their performance (money collected, phone calls made, goals, etc). I want to be able to choose from a list of these measures (possibly using a slicer) and for whichever measure I choose to populate that second column.

These measures are all imported into this spreadsheet, only a few of them are calculated of each other. I can't seem to figure out how to do this/if it's at all possible.

I need help figuring this out. If someone is willing to work with me on this I am available by phone and email too, just message me or respond to this. Thank you!

 

[dhExcel]

See Dynamic TopN Reports via Slicers, Part 2 « PowerPivotPro.

 

[jcwynes]

Thank you so much!! That works perfectly. My hero

 

[jcwynes]

You wouldn't happen to know if it is possible to do this but still display different number formats for each value (specifically PErcentages, Currency, Time, and Text)?