Is it possible to have a pivot table so that it always shows as 'expanded' all. I have a large data set and want it to show expanded with the option to collapse rather than collapsed and then have to expand. I know you can expand all in a column however on a dashboard it is easier and better viewing if already expanded.
The expandable data is in 3 columns and I am using slicers.
[TABLE="width: 360"]
<colgroup><col width="108" style="width: 81pt; mso-width-source: userset; mso-width-alt: 3949;"> <col width="124" style="width: 93pt; mso-width-source: userset; mso-width-alt: 4534;"> <col width="146" style="width: 110pt; mso-width-source: userset; mso-width-alt: 5339;"> <col width="50" style="width: 38pt; mso-width-source: userset; mso-width-alt: 1828;" span="2"> <tbody>[TR]
[TD="class: xl65, width: 108"]Protocol[/TD]
[TD="class: xl66, width: 124"]Role[/TD]
[TD="class: xl66, width: 146"]Name[/TD]
[TD="class: xl67, width: 50"]Sum of FTE Q4 2016[/TD]
[TD="class: xl68, width: 50"]Sum of FTE Q1 2017[/TD]
[/TR]
[TR]
[TD="class: xl69"]Nirap+Bev[/TD]
[TD="class: xl70"]Clinical DM[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"]0.00[/TD]
[TD="class: xl72"]0.00[/TD]
[/TR]
[TR]
[TD="class: xl69"] [/TD]
[TD="class: xl70"]Clinical Supply Chain[/TD]
[TD="class: xl70"]TBA[/TD]
[TD="class: xl71"]0.00[/TD]
[TD="class: xl72"]0.00[/TD]
[/TR]
[TR]
[TD="class: xl69"] [/TD]
[TD="class: xl70"]Compliance[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"]0.00[/TD]
[TD="class: xl72"]0.00[/TD]
[/TR]
[TR]
[TD="class: xl69"] [/TD]
[TD="class: xl70"]Contracts[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"]0.00[/TD]
[TD="class: xl72"]0.00[/TD]
[/TR]
[TR]
[TD="class: xl69"] [/TD]
[TD="class: xl70"]CTA[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"]0.00[/TD]
[TD="class: xl72"]0.00[/TD]
[/TR]
[TR]
[TD="class: xl69"] [/TD]
[TD="class: xl70"]CTM[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"]0.00[/TD]
[TD="class: xl72"]0.00[/TD]
[/TR]
[TR]
[TD="class: xl69"] [/TD]
[TD="class: xl70"]CTM [/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"]0.00[/TD]
[TD="class: xl72"]0.00[/TD]
[/TR]
[TR]
[TD="class: xl69"] [/TD]
[TD="class: xl70"]Ops Analysis[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"]0.00[/TD]
[TD="class: xl72"]0.00[/TD]
[/TR]
[TR]
[TD="class: xl69"] [/TD]
[TD="class: xl70"]RCL[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"]0.00[/TD]
[TD="class: xl72"]0.00[/TD]
[/TR]
[TR]
[TD="class: xl69"] [/TD]
[TD="class: xl70"]Sample Mgmt[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"]0.00[/TD]
[TD="class: xl72"]0.00[/TD]
[/TR]
[TR]
[TD="class: xl69"] [/TD]
[TD="class: xl70"]Sr. CTM[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"]0.00[/TD]
[TD="class: xl72"]0.00[/TD]
[/TR]
[TR]
[TD="class: xl69"] [/TD]
[TD="class: xl70"]Stats Prgm[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"]0.00[/TD]
[TD="class: xl72"]0.00[/TD]
[/TR]
[TR]
[TD="class: xl69"] [/TD]
[TD="class: xl70"]Technical DM[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"]0.00[/TD]
[TD="class: xl72"]0.00[/TD]
[/TR]
[TR]
[TD="class: xl69"]PRIMA[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"]7.48[/TD]
[TD="class: xl72"]7.48[/TD]
[/TR]
[TR]
[TD="class: xl73"]RCL M&T[/TD]
[TD="class: xl74"] [/TD]
[TD="class: xl74"] [/TD]
[TD="class: xl74"]2.60[/TD]
[TD="class: xl75"]2.60[/TD]
[/TR]
</tbody>[/TABLE]
The expandable data is in 3 columns and I am using slicers.
[TABLE="width: 360"]
<colgroup><col width="108" style="width: 81pt; mso-width-source: userset; mso-width-alt: 3949;"> <col width="124" style="width: 93pt; mso-width-source: userset; mso-width-alt: 4534;"> <col width="146" style="width: 110pt; mso-width-source: userset; mso-width-alt: 5339;"> <col width="50" style="width: 38pt; mso-width-source: userset; mso-width-alt: 1828;" span="2"> <tbody>[TR]
[TD="class: xl65, width: 108"]Protocol[/TD]
[TD="class: xl66, width: 124"]Role[/TD]
[TD="class: xl66, width: 146"]Name[/TD]
[TD="class: xl67, width: 50"]Sum of FTE Q4 2016[/TD]
[TD="class: xl68, width: 50"]Sum of FTE Q1 2017[/TD]
[/TR]
[TR]
[TD="class: xl69"]Nirap+Bev[/TD]
[TD="class: xl70"]Clinical DM[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"]0.00[/TD]
[TD="class: xl72"]0.00[/TD]
[/TR]
[TR]
[TD="class: xl69"] [/TD]
[TD="class: xl70"]Clinical Supply Chain[/TD]
[TD="class: xl70"]TBA[/TD]
[TD="class: xl71"]0.00[/TD]
[TD="class: xl72"]0.00[/TD]
[/TR]
[TR]
[TD="class: xl69"] [/TD]
[TD="class: xl70"]Compliance[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"]0.00[/TD]
[TD="class: xl72"]0.00[/TD]
[/TR]
[TR]
[TD="class: xl69"] [/TD]
[TD="class: xl70"]Contracts[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"]0.00[/TD]
[TD="class: xl72"]0.00[/TD]
[/TR]
[TR]
[TD="class: xl69"] [/TD]
[TD="class: xl70"]CTA[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"]0.00[/TD]
[TD="class: xl72"]0.00[/TD]
[/TR]
[TR]
[TD="class: xl69"] [/TD]
[TD="class: xl70"]CTM[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"]0.00[/TD]
[TD="class: xl72"]0.00[/TD]
[/TR]
[TR]
[TD="class: xl69"] [/TD]
[TD="class: xl70"]CTM [/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"]0.00[/TD]
[TD="class: xl72"]0.00[/TD]
[/TR]
[TR]
[TD="class: xl69"] [/TD]
[TD="class: xl70"]Ops Analysis[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"]0.00[/TD]
[TD="class: xl72"]0.00[/TD]
[/TR]
[TR]
[TD="class: xl69"] [/TD]
[TD="class: xl70"]RCL[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"]0.00[/TD]
[TD="class: xl72"]0.00[/TD]
[/TR]
[TR]
[TD="class: xl69"] [/TD]
[TD="class: xl70"]Sample Mgmt[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"]0.00[/TD]
[TD="class: xl72"]0.00[/TD]
[/TR]
[TR]
[TD="class: xl69"] [/TD]
[TD="class: xl70"]Sr. CTM[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"]0.00[/TD]
[TD="class: xl72"]0.00[/TD]
[/TR]
[TR]
[TD="class: xl69"] [/TD]
[TD="class: xl70"]Stats Prgm[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"]0.00[/TD]
[TD="class: xl72"]0.00[/TD]
[/TR]
[TR]
[TD="class: xl69"] [/TD]
[TD="class: xl70"]Technical DM[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"]0.00[/TD]
[TD="class: xl72"]0.00[/TD]
[/TR]
[TR]
[TD="class: xl69"]PRIMA[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"]7.48[/TD]
[TD="class: xl72"]7.48[/TD]
[/TR]
[TR]
[TD="class: xl73"]RCL M&T[/TD]
[TD="class: xl74"] [/TD]
[TD="class: xl74"] [/TD]
[TD="class: xl74"]2.60[/TD]
[TD="class: xl75"]2.60[/TD]
[/TR]
</tbody>[/TABLE]