explosive_duck
New Member
- Joined
- Jul 28, 2017
- Messages
- 6
Hi,
I am trying to find a quick way to calculate the cumulative value and percentage for multiple sets of data and below is an example of the data I have and the last 2 columns is what I am trying to calculate.
<tbody>
</tbody>
Cum Sales
This is basically where I need a running total by store and category in a descending order
Cum %
This is where I need the percentage of the cumulative sales by store and category.
Any help with this would be greatly appreciated.
Thanks.
I am trying to find a quick way to calculate the cumulative value and percentage for multiple sets of data and below is an example of the data I have and the last 2 columns is what I am trying to calculate.
Store | Category | Article | Sales Units | Cum Sales | Cum % | |||
A | Necklaces | 5424170 | 57 | 57 | 24% | |||
A |
<tbody> </tbody> |
<tbody> </tbody> | 54 | 111 | 49% | |||
A |
<tbody> </tbody> |
<tbody> </tbody> | 43 | 154 | 68% | |||
A |
<tbody> </tbody> |
<tbody> </tbody> | 38 | 192 | 85% | |||
A |
<tbody> </tbody> |
<tbody> </tbody> | 33 | 225 | 100% | |||
A | Earrings |
<tbody> </tbody> | 51 | 51 | 37% | |||
A |
<tbody> </tbody> |
<tbody> </tbody> | 51 | 102 | 74% | |||
A |
<tbody> </tbody> |
<tbody> </tbody> | 36 | 138 | 100% | |||
A | Watches |
<tbody> </tbody> | 14 | 14 | 29% | |||
A | Watches |
<tbody> </tbody> | 10 | 24 | 50% | |||
A | Watches |
<tbody> </tbody> | 9 | 33 | 69% | |||
A | Watches |
<tbody> </tbody> | 8 | 41 | 85% | |||
A | Watches |
<tbody> </tbody> | 7 | 48 | 100% | |||
B | Necklaces | 5324323 | 12 | 12 | 80% | |||
B | Necklaces | 5424170 | 3 | 15 | 100% | |||
B | Watches | 5515400 | 10 | 10 | 48% | |||
B | Watches | 5874077 | 9 | 19 | 90% | |||
B | Watches | 5874078 | 1 | 20 | 95% | |||
B | Watches | 5874081 | 1 | 21 | 100% |
<tbody>
</tbody>
Cum Sales
This is basically where I need a running total by store and category in a descending order
Cum %
This is where I need the percentage of the cumulative sales by store and category.
Any help with this would be greatly appreciated.
Thanks.