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% |