Creating a Pivot Table Card where the default view is COLLAPSED

Reply
Highlighted
White Belt

Creating a Pivot Table Card where the default view is COLLAPSED

Hi Everyone...

 

First post here. Just finished my professional cert level 1 to give you an idea of knowledge level.

 

I created a pivot table chart and by default I have a QTD date range broken out by weeks. My column hierarchy goes -> Week (based on our fiscal calendar) -> Campaigns -> dimensions/metrics.

 

We might be running 30-50 campaigns a week and as you can imagine the view is unwieldy when everything is expanded. I can't seem to find a way to enable the default view where everything is collapsed starting from the top (week). Is it even possible?  

Highlighted
Major Brown Belt

Hi @user065422 

 

Have you tried utilizing a quick filter instead to view only the campaigns the user is interested? There isn't a default "collapsed" option (you could manually collapse all of them and then save the report but that'd be a weekly or daily process to keep updating the collapses)



**Was this post helpful? Click the heart icon**

**Did this solve your problem? Accept it as a solution!**
Announcements
Stand out in the Dojo: Choose your own recognizable username and add a unique profile photo in your profile settings.