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.