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 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.
| Group Segment | Sales 2019/2020 | Sales 2018/2019 | Growth 2019/2020 | Outlet Growth |
| Corporate | 1 358 041 | 2 932 912 | -54% | 63% |
| Corporate Budget | 3 673 926 | 1 569 143 | 134% | 100% |
| Hyper | 595 055 | 1 097 352 | -46% | 38% |
| Mini Market | 143 105 | 92 792 | 54% | 75% |
| Family | 11 839 947 | 7 082 048 | 67% | 54% |
| Family Budget | 4 286 221 | 1 535 568 | 179% | 100% |
| Total | 21 896 295 | 14 309 814 | 53% | 66% |
