Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how can i add a total row at the bottom of a P&L pivot table, please help
@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')
@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')