I have below table in qlikview with GL entries. The requirement here is prior period value for income/expense should be shown in Equity row of Prior Period / Month column. How this can be achieved ? Is there a way using set analysis or Aggr() in this case.
Dimensions are GL Category & Expression is using sum of amount with specific GL Category.
