Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Hello.
Try using set analysis - Sum({1} Sales). This will disregard the selection in Year.
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
Thanks guys, works perfectly