Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I need to show a pivot table it based on selection in a multibox or else it should be hidden..............
Can you please tell me how is it?
Any Particular field in Multi box? Here I'm Assuming your field as Year
Use this in Pivot Chart > Layout > Show Conditional
=GetSelectedCount(Year)>0
Any Particular field in Multi box? Here I'm Assuming your field as Year
Use this in Pivot Chart > Layout > Show Conditional
=GetSelectedCount(Year)>0
Hi,
go to chart Property->Layout->enter condition->if(getselectedcount(fielname)>0,1,0)
Regards
Or, even wihtout IF, like:
=getselectedcount(fieldname)
Considering you have 3 fields in multibox as Field1, Field2 and Field3
Go to chart properties -> Layout tab-> check conditional and put below expression there
if(getselectedcount(Field1)> 0 or getselectedcount(Field2)> 0 or getselectedcount(Field3)> 0, 1,0)
Hi
Try like this
chart properties -> Layout -> conditional
= Getselectedcount(FieldName1) or Getselectedcount(FieldName2)
hi,
I hope it will help u to complete the task
In a multi box u r holding how many filters in it ?
For Ex:3 filters x,y,z
if u r going to select x it should display corresponding x filter values in a pivot table
for that
Pivot Chart > Layout > Show Conditional
=GetSelectedCount(x)>0
it will display only for filter 'X'
if it want to work for all the filters dynamically means
Pivot Chart > Layout > Show Conditional
=(GetSelectedCount(x) + GetSelectedCount(y) + GetSelectedCount(z))>0
it will work for all the filters.
Thanks and Regards
Balaji.k