Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello Guys ,
image below is pivot table ,i need to disspear only dimension column as shown in red in chart, but i want rest the same ,how can i achieve this ?? iwant output as shown in second image??
You mean just hide it? You can't do a true column hide in pivot tables like you can in straight tables, but you can make the text white and shrink the column to be very narrow. BUT...why don't you just make it a straight table? Looks like it would work fine with your chart above since you don't have any dimensions pivoted across the top or anything like that. Columns can be hidden in straight tables through the Presentation tab.
Regards,
Vlad
You mean just hide it? You can't do a true column hide in pivot tables like you can in straight tables, but you can make the text white and shrink the column to be very narrow. BUT...why don't you just make it a straight table? Looks like it would work fine with your chart above since you don't have any dimensions pivoted across the top or anything like that. Columns can be hidden in straight tables through the Presentation tab.
Regards,
Vlad