Dear All,
I do have Stylewise Weekwise % Mix Sample data set across A1:I3 as follows:-
<tbody>
</tbody> I would like to find out how many weeks % Mix contribute to 45%-50%, 75%-80% & 100%
My desired Result across A5:D7 is as follows:-
<tbody>
</tbody>Above metrics indicates that for Style A, 5 Weeks sales contribute between 45%-50%, 5 Weeks sales contribute between 75%-80% & 8 weeks contribute 100%.
Similarly,Above metrics indicates that for Style B, 4 Weeks sales contribute between 45%-50%, 6 Weeks sales contribute between 75%-80% & 8 weeks contribute 100%.
Could somebody help to solve my issue?
Regards
I do have Stylewise Weekwise % Mix Sample data set across A1:I3 as follows:-
Style | Week-1 | Week-2 | Week-3 | Week-4 | Week-5 | Week-6 | Week-7 | Week-8 |
A | 12% | 14% | 18% | 20% | 10% | 11% | 8% | 7% |
B | 10% | 12% | 14% | 15% | 16% | 13% | 10% | 10% |
<tbody>
</tbody>
My desired Result across A5:D7 is as follows:-
Style | 45%-50% | 75%-80% | 100% |
A | 5 | 5 | 8 |
B | 4 | 6 | 8 |
<tbody>
</tbody>
Similarly,Above metrics indicates that for Style B, 4 Weeks sales contribute between 45%-50%, 6 Weeks sales contribute between 75%-80% & 8 weeks contribute 100%.
Could somebody help to solve my issue?
Regards