hatahetahmad
New Member
 Joined
 Jan 8, 2016
 Messages
 31
Hello, I have very simple data, that I want to group by SUM
As the uploaded image shows. My Data has 3 columns, first comes Index, Numbers then Group, which I want to fill according to specific limit cell H2.
I started by summing like cumulative column, then divided the result by the limit and rounded up to 0 decimals.
It showed me groups but some groups have more than the limit, therefor incorrect solution.
Results should be: Cell C2 and C3 should show 1 , Cell C4 should show 2 , Cell C5 and C6 should show 3 , Cell C7 and C8 should show 4 , Cell C9 should show 5 ...
The Idea is straight but not simple to execute.
I'm open to any solution using Excel Formulas, DAX or M
You can download the file from here
Please advise me.
Many Many Thanks
As the uploaded image shows. My Data has 3 columns, first comes Index, Numbers then Group, which I want to fill according to specific limit cell H2.
I started by summing like cumulative column, then divided the result by the limit and rounded up to 0 decimals.
It showed me groups but some groups have more than the limit, therefor incorrect solution.
Results should be: Cell C2 and C3 should show 1 , Cell C4 should show 2 , Cell C5 and C6 should show 3 , Cell C7 and C8 should show 4 , Cell C9 should show 5 ...
The Idea is straight but not simple to execute.
I'm open to any solution using Excel Formulas, DAX or M
You can download the file from here
test group by sum.xlsx
drive.google.com
Please advise me.
Many Many Thanks
Attachments

81 KB Views: 5