Hide entire pivot table column

[trozzi1957]

Hi-

I want to hide entire pivot table set of columns created using the following code...

pt.DataFields.Add(pt.PivotFields["Rode"], "Rode", SubtotalTypes.Sum);
pt.DataFields.Add(pt.PivotFields["OnTime"], "OnTime", SubtotalTypes.Sum);

I want to hide "Rode" and "OnTime" after calculating their column total.

Thanks
-Tom

[trozzi1957]

I want to uncheck the columns showing the datafields on the report boxes programmatically... the checkboxes are in the right panel.

[amy.zhao]

Hi Tom,

Thanks for your inquiry.

Please refer to the following code:

Code: Select all

var c1 = pt.PivotFields["Rode"];
c1.Axis = AxisTypes.Column;
pt.DataFields.Add(pt.PivotFields["Rode"], "Rode", SubtotalTypes.Sum);
pt.CalculateData();
((XlsPivotField)c1).HideAllItem(true);


If this does not meet your requirements, please let me know and provide me with a sample document or screenshot showing the desired outcome. I will do further investigation. Thank you for your assistance.

Sincerely,
Amy
E-iceblue support team

[amy.zhao]

Hello,

Hope you are doing well.

Has your issue been solved?

I look forward to receiving your feedback.

Sincerely,
Amy
E-iceblue support team