property from listbox changes in all listboxes with the same name
I have a listbox with the weeks 1 to 52 (from master calendar) in sheet A and another listbox (NOT LINKED) with the same name with the weeks 1 to 52 (from master calendar) in SHEET B.
I want to change the properties from the listbox in sheet A: only a selection from ONE week and in sheet B a selection from multiple weeks.
When I change the properties of the listbox in sheet A (Mark `only one selected value`), the properties from the listbox in sheet B changed as well.
Although the check box to turn on only one selected value is on the list box properties the option actually relates to the field. If you think about it if a field can only have one selected value then this affects everywhere it appears.
It may be that you actually need to have two separate fields in order to achieve what you want.
Alternatively it may be that you require Set Analysis in the expression on the tab where you only want to see one week, for example:
SUM({<WeekNo={$(=max(WeekNo))}>}SalesValue)
As the list box will give the impression that all weeks are selected you will want to alter the caption on the chart to show the week number, for example:
