show/hide of columns in a pivot table

[#1]

Hello together,

I have a list box

Listbox
customer 1
customer 2

and a Pivot Table:

amount	customer 1	customer 2
2121	2121
5212		5212

Could you help me, that I get this view (customer 1 is active)

Listbox
customer 1
costumer 2

Pivot Table:

amount	customer 1
2121	2121

if the customer 2 in the listbox is active, the pivot showing the amount and the customer 2 view.

Could you help me to solve this problem.

Thank you.

[nirav_bhimani]

Hi,

You can try this.

=SubStringCount(Concat(listbox,'|'),'customer2 ') in Expression tab conditional

Regards,

Nirav Bhimani

[#3]

HI ,

      Try to have the Expression in the Conditional Box of each Expression

for column Customer1 confditional

= if(IsNull( GetCurrentSelections()) ,0,SubStringCount(GetCurrentSelections(), 'Customer1'))

and for Customer2 conditional expression

= if(IsNull( GetCurrentSelections()) ,0,SubStringCount(GetCurrentSelections(), 'Customer2'))

//Yusuf

[#4]

Hello Nirav,

sorry it doesn't work, where is the expressio tab, where can i find it?

[#5]

Hej,

it doesn't work, it shows only a 0 in the column. If I click one of the listbox, the other column is visible.

Do you know why?

[#6 · Accepted solution]

HI ,

    The Values Present in the ListBox for Customer1 and Customer2 so use the same text in the Expression mentioned below .

I see at present the text in the ListBox is "Customoer 1" but we gave solution with the text as "Customer1" .

So include the text "Customer 1"(Same as present in the ListBox ) in  the Expression below,

= if(IsNull( GetCurrentSelections()) ,0,SubStringCount(GetCurrentSelections(), 'Customer 1'))

and for Customer2 conditional expression

= if(IsNull( GetCurrentSelections()) ,0,SubStringCount(GetCurrentSelections(), 'Customer 2'))

Please let me know if there is anything .

//Yusuf

[nirav_bhimani]

HI,

Go to your pivot table properties > Expression Tab in the top right corner check conditional and then paste the the expression for each Expression like.

=SubStringCount(Concat(FiledName,'|'),'value')

Also find the attachment for more detail.

Regards,

Nirav Bhimani