How to ignore selections for a dimension in a straight table?

[#1]

I've got a straight table with Year as dimension and Sum(Sales) as expression (and as a mini-chart). I want the table to show the sum of sales and mini-chart by months for all years, which would be the same as making no selections at all in the Year-listbox. Problem is that every time a user choose a Year the straight table updates to the choosen years. Though I whould like the straight table to act somewhat like a summary for all years.

Any ideas?

best regards.

[john_duffy]

Hello.

Try using set analysis - Sum({1} Sales).  This will disregard the selection in Year.

[erichshiino · Accepted solution]

Hi, You can use:

Sum({1} Sales) - If you want to ignore any selections

You can use:

Sum({<Year = >} Sales)  - If you want to ignore selections in the field Year

You can include other fields you want to ignore:

Sum({<Year = , SalesPerson = >} Sales) - it ignores selections in year and SalesPerson

Hope this helps,

Erich

[#4]

Thanks guys, works perfectly