PIVOT TABLE ISSUE

[#1]

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.

[#2]

In straight table

Go to Presentation >> Hide Columns.

Will hide your desire column.

Vinay

[#3]

I am using the PIVOt Table

[Anonymous]

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

[#5]

as you said you wanna use straight table. so you can hide/show  columns.

[#6]

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

[#7]

Where Do I place this Sub Routine at ??

[#8]

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.

[#9]

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.