cancel
Showing results for 
Search instead for 
Did you mean: 

Expand and collapse pivot table

ScheurK
9 - Travel Pro
9 - Travel Pro

Hi all,

Running Sisense L2022.1. I'm getting a lot of requests for expanding and collapsing data within pivot tables. Is this possible?
The problem with the drill-down functionality is that it also filters on the value you selected, sometimes I don't want that.

Kind regards!

1 ACCEPTED SOLUTION

harikm007
12 - Data Integration
12 - Data Integration

Hi @ScheurK ,

Few plugins (premium) are available in market place for this:

1. https://www.sisense.com/marketplace/interactive-pivot/

2. https://www.sisense.com/marketplace/premium-expandable-pivot-table/

3. https://www.sisense.com/marketplace/advanced-expandable-pivot-table/

 

You can also try Switchable Dimension, so that, instead of  expand and collapse you can switch the dimension (if that works for you)

https://www.sisense.com/marketplace/switchable-dimensions/

 

-Hari

 

View solution in original post

2 REPLIES 2

HamzaJ
10 - ETL
10 - ETL

I dont think this is possible within the native pivot. I do know that both Paldi and QbeeQ offer a premium plugin that make collapsing and expanding rows and columns possible

harikm007
12 - Data Integration
12 - Data Integration

Hi @ScheurK ,

Few plugins (premium) are available in market place for this:

1. https://www.sisense.com/marketplace/interactive-pivot/

2. https://www.sisense.com/marketplace/premium-expandable-pivot-table/

3. https://www.sisense.com/marketplace/advanced-expandable-pivot-table/

 

You can also try Switchable Dimension, so that, instead of  expand and collapse you can switch the dimension (if that works for you)

https://www.sisense.com/marketplace/switchable-dimensions/

 

-Hari

 

Voice of Customer
Impact Business Intelligence (BI) and Analytics Market Research

Click Here & Complete Dresner's Wisdom of Crowds® Market Study Survey Today!

Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Need additional support?:

Community Support Request

Don't miss out:

Earn a BETA Launch Challenge Badge!