P&L Table Total

[Anonymous]

how can i add a total row at the bottom of a P&L pivot table, please help

[Kushal_Chawda · Accepted solution]

@Anonymous  Create a inline table in script like below

LOAD * inline [
Dim
1
2 ];

Now, in pivot table replace your Type Dimension with below

=Pick(Dim,Type,'Total')