topic Re: Adding a calculated row to a pivot table in App Development

Adding a calculated row to a pivot table

Chandimal — Sat, 16 Nov 2024 05:23:51 GMT

Hi,

I have a requirement to add a calculated row into the pivot table. In my table I'm representing annual turnover of five different companies along with the annual budget. Columns represents the companies.Rows represents the annual turnover and annual budget.

My requirement is to show each individual achievement percentage on the bottom row by dividing budget/ turnover *100

Any possibility to do this

Re: Adding a calculated row to a pivot table

Simon_Astakhov — Wed, 03 Jul 2019 14:04:02 GMT

Can you provide current situation and required solution in any image, for example?

Re: Adding a calculated row to a pivot table

Chandimal — Wed, 03 Jul 2019 14:24:22 GMT

I have attached a screenshot for your reference.

My requirement is to add a calculated row as the bottom row for the pivot table

values in the first row "corporate plan" must be divided by the values of the second row "May-2019" and multiply that by 100 to get the percentage value.

Each field must represent the corresponding percentage value on the bottom field of each column

Hope you can get the idea

Re: Adding a calculated row to a pivot table

Simon_Astakhov — Wed, 03 Jul 2019 14:56:56 GMT

If its acceptable, you can add custom first line by enabling Totals for Details dimension like:

And expression like: IF(Dimensionality()=0, 'budget/ turnover *100', Sum(Value)).

Just replace 'budget/ turnover *100' string by another formula.

Re: Adding a calculated row to a pivot table

Chandimal — Wed, 03 Jul 2019 15:25:19 GMT

Hi Simon,

Any possibility to do this with new P&L Pivot table