Adding a calculated row to a pivot table

[Chandimal]

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

[Simon_Astakhov]

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

[Chandimal]

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 

[Simon_Astakhov]

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.

[Chandimal]

Hi Simon, 

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