Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a straight table chart that displays what was sold for a selected quarter and year, the last column in my table chart is an overall amount expression of all sales for this item throught time. So this column needs to ignore the selected year and quarter and sum up the total sales.
=SUM({<Year=,Quarter=} NetAmount)
When I do this, my table chart blows up with more rows of data of products that did not sell during the date selection. The column with the total for the current time period shows zero, but has value for the overall sum. So it looks like ignoring the selection in my expression added more selection to the chart. The goal is to keep the selection for the chart, but not for a single column. What am I going wrong?
Change your expression to this:
=SUM({<Year=,Quarter=} TOTAL NetAmount)
The total for each item is the same, looks like its summing up everything rather than seperating by product
Do you have the Show All Values checked on your dimensions? If you do, uncheck them. Here's a sample file with the same idea of what you're trying to do.