Pivot table "Value Field Settings"

Aug 4, 2014 at 8:11 PM
Hey there.

I've been trying to use ClosedXML to generate a group of Excel files systematically.

One of the tabs contains a Pivot Table that I was already able to add but I can't find a way to set the fields to "Show values as % of Column Total", this is an option that can be selected by going to "Options -> Show Values As" when the Pivot Table is selected.

Is it possible to do this with ClosedXML?

Thank you for your help and for the great tool you have developed!