Here I'm trying to create P&L report including some variables to simulate different scenarios.
Here I have the P&L structure configured as shown in the below image.
What I'm trying to create a table as shown as in the below image.
The expression I have used for calculating [Amount*Variable] =
aggr(sum(amount),[P&L Layout],[Row No])*sum(pick(match(P&L Lines,Variable),Varaible))
The resulting table is as shown in the below image.
Can anyone suggest any possible solution to solve this problem?
Any help is greatly appreciated.
Thanks in advance.