Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Attached is the Desired Reult I am trying to Achieve, But I dont want the First Column( TOT1 and TOT 2). I am using a Pivot Table right now but I wanna use the Straight Table. If Possible.
In straight table
Go to Presentation >> Hide Columns.
Will hide your desire column.
Vinay
I am using the PIVOt Table
Hi Ray,
Hide First Column( TOT1 and TOT 2) - do you want to hide columns and calculate only remaining column values
In Straight table - grouping of dimensions is not possible like pivot table.
Pivot table - grouping of dimensions is possible in pivot table,it is often used with sub-totals
as you said you wanna use straight table. so you can hide/show columns.
you can use simple one time macro to hide column in pivot table
sub Hidecol
call Hidecolumn(''CH01'',1)
end sub
private sub Hidecolumn(ch,n)
set ch = activedocument.getsheetobject(ch)
ch.setpixwidth (n-1),0
end sub
Where Do I place this Sub Routine at ??
cntrl+ M gives you the macro editor , write this macro (make sure to use your chart number and hiding column number) and run it once.
Well I have to use the Straight Table, cuz I am using Mini Charts and I dont have an option of Mini Charts in PIVOT Table, How can I accomplish The Subtotals in Straight Table for a Group of Dimensions.