how to make a selection box for multiple fields (sales, quantity, sep) so that when one is selected (sales) all charts show (sales) data

[Anonymous]

how to make a selection box for multiple fields (sales, quantity, sep) so that when one is selected (sales) all charts show (sales) data

[CELAMBARASAN · Accepted solution]

Hi,

     Use this as condition

     =SubStringCount(Concat(UnitSelection, '|'), 'Sales') for sales exp

     =SubStringCount(Concat(UnitSelection, '|'), 'SEP') for SEP exp

     =SubStringCount(Concat(UnitSelection, '|'), 'Quantity') for Quantity exp

Celambarasan

[Anonymous]

awesome, works perfect for my straight tables

shows all the data, Sales, SEP and Quantity when none of those are selected in my UnitSelection listbox. and Just what is selected when a selection is made.

Can you help with my bar charts as well?

I want to do the same thing, but I don't want all the data to show when nothing is selected.  Is there a way to hide Quantity and Sales?

[CELAMBARASAN]

Hi,

     Use getFieldSelections instead of Concat

      =SubStringCount(GetFieldSelections(UnitSelection, '|',10), 'Sales')

      =SubStringCount(GetFieldSelections(UnitSelection, '|',10), 'Quantity')

Celambarasan