Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
as you can see in the image below , i want to use %dimensions as a cyclic group. but my problems is :
for exemple if i select 'Category' in the %dimensions listbox and the cyclic group is on 'Category' => the graph will display 100 % which make no sense.
so i want to remove dynamically from the cyclic group the item selected on the %dimensions list box.
any idea ?.
Sorry, but here what i should get : for exemple if i select category in the %dimensions:
and in this case : the cyclic group shouldn't contain the Category in the list of choices.
Check the attachment for the solution
what i want to do is :
- when Country is selected in the listbox the cyclic group should contain only : Product and Category
- when Category is selected in the listbox the cyclic group should contain only : Product and Country
- when Product is selected in the listbox the cyclic group should contain only : Category and Country
- when Country and Category are selected in the listbox then the cyclic group should contain only Product
- when Country and Product are selected in the listbox then the cyclic group should contain only Category
- when Product and Category are selected in the listbox then the cyclic group should contain only Country.
and all this dynamically because the number of items in the listbox can increase over time.
and what if nothing is selected in the listbox, are you expecting to see all three ?
Hi, it is not beautiful solution, but it is . You may use several cyclic dimensions. Then, show or hide depend on selections in appropriate field.
i use a conditional display : GetSelectedCount(%dimensions)>0