I created a pivot table that displays sales across different dimension. I wanted to put the total sales on top of the sheet. So I created a measure called Total Sales=Sum(Sales) and threw on to the top of the sheet. The total is correct as I checked and it changes in response to all kinds of filtering. But there is a message saying "Error: Garbage Over Expression" on the total Box.
Don't know why.
Message was edited by: Buyi Zhang
Make sure your Sales data is numeric. You can also try something like this:
Could you please take a snapshot of the screen with expression?
If you are trying to start with a text concatenated with an expression you need to have it in this format:
="Total Sales = "&Sum(Sales)
That might fix the expression!