topic Re: A custom column in pivot Table in App Development

A custom column in pivot Table

Pragun — Sat, 16 Nov 2024 05:08:49 GMT

I want to add a calculated column in the pivot table(% of progressive status) which would take an expression and calculate it on the basis of data in that row.

currently I have :

row : Insp.Lot Origin

Column : MonthYear

How can this 3rd column be added to the pivot table

Re: A custom column in pivot Table

jonathandienst — Mon, 29 Jul 2019 05:12:29 GMT

Please explain the calculation you would like to perform.

Re: A custom column in pivot Table

Pragun — Mon, 29 Jul 2019 06:10:56 GMT

in the pivot table I am showing lets say pending lots. In the calculated column I want to show sum of all pending lots from all the months divided by total lots for all the months for the given Insp.Lot origin