Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
greend21
Creator III
Creator III

Hide Dimension in Pivot Table or Show Blanks for Repeating Dimensions

Right now I am trying to set up three pivot tables right next to eachother with the same dimensions of date and payment type so I would like to hide the dimensions on the 2nd and 3rd tables. Does anyone know how this is possible? The issue is that the column categories needed for it to be one pivot would be difficult to throw into the data model, so we wanted to go this route.

Another option is to just use a straight table since I can add in all of the measures but I would like to hide repeating dimension values. I have the paid Vizlib extensions available for use as well but did not see any options for either situation. For example, if we have checks and wires I want it look like this

5/19/2019PaymentType1###$$$
 PaymentType2###$$$
 PaymentType3###$$$
 PaymentType4###$$$

 

and not this

5/19/2019PaymentType1###$$$
5/19/2019PaymentType2###$$$
5/19/2019PaymentType3###$$$
5/19/2019PaymentType4###$$$

 

EDIT: The pivot would be preferable because I need subtotals by date.

 

Labels (1)
2 Replies
joaopaulo_delco
Partner - Creator III
Partner - Creator III

Go to the chart properts > Presentation section and flag the "Fully expanded" option.

Help users find answers! Don't forget to mark a solution that worked for you!
greend21
Creator III
Creator III
Author

Well if I stick to a pivot table I actually want to hide the date and payment type dimensions from view but still have the measures displayed as if they were fully expanded so that they all line up.

The layout examples I provided would be a straight table so there wouldn't be any expanding.