This content has been marked as final. Show 13 replies
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