• ptownbro - Wednesday, January 18, 2017 7:41 PM

    Here's a picture of what it looks like.  You can see where it says "2014 Actual" and "2015 Budget". In the field list, but the underlying database all labels say "Actual" and "Budget" respectively (as it shows even in the "values" section).

    Someone has simply typed over the cell in the pivot table. For some reason it changes the name of the measure in the Pivot Table field list when you do this. Change it to something else to see it in action. The clue to this is that in your values box in the Pivot Table field list, the measures have retained their names as defined in SSAS.


    I'm on LinkedIn