https://community.qlik.com/t5/QlikView/Help-on-Pivot-table/m-p/1857825#M1215973 <P>Hi All,</P> <P>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.</P> <P>Dimensions are GL Category &amp; Expression is using sum of amount with specific GL Category.</P> <P>&nbsp;</P> <TABLE width="480"> <TBODY> <TR> <TD width="164">&nbsp;</TD> <TD width="61">Month1</TD> <TD width="81">Prior Period</TD> <TD width="55">Month2</TD> <TD width="55">Prior Period</TD> <TD width="64">Month3</TD> </TR> <TR> <TD>Asset</TD> <TD>100</TD> <TD>&nbsp;</TD> <TD>200</TD> <TD>&nbsp;</TD> <TD>200</TD> </TR> <TR> <TD>Current Liabilities</TD> <TD>25</TD> <TD>&nbsp;</TD> <TD>25</TD> <TD>&nbsp;</TD> <TD>25</TD> </TR> <TR> <TD>Equity</TD> <TD>50<STRONG>+10</STRONG></TD> <TD>&nbsp;</TD> <TD>15<STRONG>+5</STRONG></TD> <TD>&nbsp;</TD> <TD>15</TD> </TR> <TR> <TD>Current Income/Expense</TD> <TD>20</TD> <TD><STRONG>10</STRONG></TD> <TD>21</TD> <TD><STRONG>5</STRONG></TD> <TD>21</TD> </TR> </TBODY> </TABLE> Wed, 10 Nov 2021 16:42:19 GMT manojkulkarni 2021-11-10T16:42:19Z https://community.qlik.com/t5/QlikView/Help-on-Pivot-table/m-p/1857825#M1215973 <P>Hi All,</P> <P>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.</P> <P>Dimensions are GL Category &amp; Expression is using sum of amount with specific GL Category.</P> <P>&nbsp;</P> <TABLE width="480"> <TBODY> <TR> <TD width="164">&nbsp;</TD> <TD width="61">Month1</TD> <TD width="81">Prior Period</TD> <TD width="55">Month2</TD> <TD width="55">Prior Period</TD> <TD width="64">Month3</TD> </TR> <TR> <TD>Asset</TD> <TD>100</TD> <TD>&nbsp;</TD> <TD>200</TD> <TD>&nbsp;</TD> <TD>200</TD> </TR> <TR> <TD>Current Liabilities</TD> <TD>25</TD> <TD>&nbsp;</TD> <TD>25</TD> <TD>&nbsp;</TD> <TD>25</TD> </TR> <TR> <TD>Equity</TD> <TD>50<STRONG>+10</STRONG></TD> <TD>&nbsp;</TD> <TD>15<STRONG>+5</STRONG></TD> <TD>&nbsp;</TD> <TD>15</TD> </TR> <TR> <TD>Current Income/Expense</TD> <TD>20</TD> <TD><STRONG>10</STRONG></TD> <TD>21</TD> <TD><STRONG>5</STRONG></TD> <TD>21</TD> </TR> </TBODY> </TABLE> Wed, 10 Nov 2021 16:42:19 GMT https://community.qlik.com/t5/QlikView/Help-on-Pivot-table/m-p/1857825#M1215973 manojkulkarni 2021-11-10T16:42:19Z