https://community.qlik.com/t5/QlikView/Qlikview/m-p/1708042#M724530 <P>Hello, I have multiple group segment each with designated stores. I want to calculate the percentage of store that had a positive growth from last year to current year for each group segment&nbsp; e.g. Corporate Segment has 10 store in total, 7 stores had positive growth in 2020 so 70% outlet growth. Now I want to present this in a chat showing only Group Segment and outlet growth per segment (Calculation is based on stores but I don’t want to show store in the table/dimension) i.e.</P><TABLE width="418"><TBODY><TR><TD width="134">Group Segment</TD><TD width="80">Sales 2019/2020</TD><TD width="68">Sales 2018/2019</TD><TD width="72">Growth 2019/2020</TD><TD width="64">Outlet Growth</TD></TR><TR><TD>Corporate</TD><TD>1 358 041</TD><TD>2 932 912</TD><TD>-54%</TD><TD>63%</TD></TR><TR><TD>Corporate Budget</TD><TD>3 673 926</TD><TD>1 569 143</TD><TD>134%</TD><TD>100%</TD></TR><TR><TD>Hyper</TD><TD>595 055</TD><TD>1 097 352</TD><TD>-46%</TD><TD>38%</TD></TR><TR><TD>Mini Market</TD><TD>143 105</TD><TD>92 792</TD><TD>54%</TD><TD>75%</TD></TR><TR><TD>Family</TD><TD>11 839 947</TD><TD>7 082 048</TD><TD>67%</TD><TD>54%</TD></TR><TR><TD>Family Budget</TD><TD>4 286 221</TD><TD>1 535 568</TD><TD>179%</TD><TD>100%</TD></TR><TR><TD>Total</TD><TD>21 896 295</TD><TD>14 309 814</TD><TD>53%</TD><TD>66%</TD></TR></TBODY></TABLE> Wed, 25 Nov 2020 16:16:04 GMT Neo 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Qlikview/m-p/1708042#M724530 <P>Hello, I have multiple group segment each with designated stores. I want to calculate the percentage of store that had a positive growth from last year to current year for each group segment&nbsp; e.g. Corporate Segment has 10 store in total, 7 stores had positive growth in 2020 so 70% outlet growth. Now I want to present this in a chat showing only Group Segment and outlet growth per segment (Calculation is based on stores but I don’t want to show store in the table/dimension) i.e.</P><TABLE width="418"><TBODY><TR><TD width="134">Group Segment</TD><TD width="80">Sales 2019/2020</TD><TD width="68">Sales 2018/2019</TD><TD width="72">Growth 2019/2020</TD><TD width="64">Outlet Growth</TD></TR><TR><TD>Corporate</TD><TD>1 358 041</TD><TD>2 932 912</TD><TD>-54%</TD><TD>63%</TD></TR><TR><TD>Corporate Budget</TD><TD>3 673 926</TD><TD>1 569 143</TD><TD>134%</TD><TD>100%</TD></TR><TR><TD>Hyper</TD><TD>595 055</TD><TD>1 097 352</TD><TD>-46%</TD><TD>38%</TD></TR><TR><TD>Mini Market</TD><TD>143 105</TD><TD>92 792</TD><TD>54%</TD><TD>75%</TD></TR><TR><TD>Family</TD><TD>11 839 947</TD><TD>7 082 048</TD><TD>67%</TD><TD>54%</TD></TR><TR><TD>Family Budget</TD><TD>4 286 221</TD><TD>1 535 568</TD><TD>179%</TD><TD>100%</TD></TR><TR><TD>Total</TD><TD>21 896 295</TD><TD>14 309 814</TD><TD>53%</TD><TD>66%</TD></TR></TBODY></TABLE> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Qlikview/m-p/1708042#M724530 Neo 2020-11-25T16:16:04Z