Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Thanks
Message was edited by: Buyi Zhang
HI,
Can you share the expression you have in the title of this measure, looks like that has some problem. See the image below to identify the place I am talking about -
My "Show Title" toggle was off. The error persists when I tried to put title in.
In the "Edit Measure" popup menu, Expression box, I only put in Sum(Sales) . I tried your suggestion nevertheless--did not work. Thanks
Can you share what is showing up in your title?