Showing results for 
Search instead for 
Did you mean: 

How to switch off Pivot2 columns?

8 - Cloud Apps
8 - Cloud Apps

I am looking for a script to switch off columns in pivot2. This option would be available to users, so I suppose I would link it to a Blox botton.

The case is that we use dates in columns and several values. So when half of the month passes the table becomes quite extensive. I would like to be able to switch off columns and have values aggregated by the current month. I have tried to use dimention changer (days / months) but when the agregation is by months, the widget ignores the dashboard filter and shows all months available in the datamodel.



Sisense Team Member
Sisense Team Member

Hi Laris,

The script can be found here.

The behavior you experience is as follows:

  • As with any dimension, pivot columns can be filtered.
  • By default, if both widgets and dashboards have filters on the same dimension, then only the widget filter is applied.
  • There is one exception to the above rule - multiple filters on the same date dimension can be applied if they are set on a different date level. Dashboard and widget defined with date dimension filters with the same date level will only use widget filter 

Hi, Guyraz,

thank you for your reply. Indeed I have seen that script and tried to modify it but haven't succeed yet.

I think I wasn't clear. The script you propose deals with the "Values", and I am looking for a way to let users switch on/off the columns without entering inside the widget.