ASS FORMULA INTO PIVOT

[ict@sogedin.it]

Is possible insert formula table pivot ??
thanks

[amy.zhao]

Hello,

Thanks for your inquiry.
Please kindly try the below method.

Code: Select all

pivotTable.CalculatedFields.Add(string name, string formula);

Best wishes,
Amy

[amy.zhao]

Hello,

Have you tried the method? How did it work?
Thanks for your feedback.

Best wishes,
Amy

[ict@sogedin.it]

I'm sorry I confused the posts
I have two fields
pt.DataFields.Add (pt.PivotFields ["value"], "Performance Amount" SubtotalTypes.Sum);
pt.DataFields.Add (pt.PivotFields ["ValoreDrg"], "DRG Amount" SubtotalTypes.Sum);
I have to make the difference between the two as I do?
thanks

[amy.zhao]

Hello,

They are two different dataFields. But they should be written:

Code: Select all

pt.DataFields.Add (pt.PivotFields ["value"], "Performance Amount", SubtotalTypes.Sum);
pt.DataFields.Add (pt.PivotFields ["ValoreDrg"], "DRG Amount", SubtotalTypes.Sum);

Best wishes,
Amy

[ict@sogedin.it]

yes, but I want another field with the difference between the two
pt.DataFields.Add (pt.PivotFields ["Difference"], Difference", [value] - [Valoredrg]);
is possible ??

[Gary.zhang]

Hello,

Sorry that at present our library doesn't support the function.

If there are any questions, welcome to get it back to us.

Sincerely,
Gary
E-iceblue support team