How to create a Slicer for Measures and capture the item selected.
In an Excel PivotTable you can't create a Slicer for your measures, In a cube formula report you can. This video shows you how. It also shows how you can capture the item selected for use, say, in your report title.