how to apply formula's to pivot table using closedxml

See more:

C#

MS-Excel

Hi folk,

I am Closedxml sdk to generate pivot table in c#.
I am not able to use formula's to pivot table.

Please anybody help me to solve this issue.

pt.Values.Add("EmpID", "Head Count").SummaryFormula = XLPivotSummary.Count;

          pt.Values.Add("forcastedRev").SummaryFormula = XLPivotSummary.Sum;

when i run the code pivot table sheet comes as empty.


Thanks,
Syed