Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I am just wondering if there's a way where I can prevent the user to do the "Clear all selections" but at the same time they will be able to do multi selection. For example list box for Months (January until December), I want the user to be able to select January, February and March but they won't be able to do "Clear all selection", at least one value has to be selected.
Thanks in advance!
We do weighted average for YTD and not for Month data. I have another solution for this, I created 2 tables, one for Month and one table for YTD and put them in the container. I set the Month filter to "Always One Selected Value" and only affected the Month data not the YTD.
I think there should be a better way to do this..
does ur YTD data depends upon Month.
If not then Filter it or bypass it in set analysis.
Sum({<Month=>}Value).
In this way ur selection on month will not affect ur YTD data.