Hi guys,
Wonder if any of you have encountered a similar scenario:
I've got a table similar to the following one, with a few hundreds of different entities where each of them have its own specific "length". Don't know how exactly explain it but I would like to group the Q by buckets of "cycles" (First 4 Q = cycle 1 ; 2nd set of 4Q cycle 2 and so on...until it reaches the following entity where the grouping should be restarted.
As follows:
I know it's a very specific question but any workaround / formula to solve this would be much appreciated.
Many thanks,
J
Wonder if any of you have encountered a similar scenario:
I've got a table similar to the following one, with a few hundreds of different entities where each of them have its own specific "length". Don't know how exactly explain it but I would like to group the Q by buckets of "cycles" (First 4 Q = cycle 1 ; 2nd set of 4Q cycle 2 and so on...until it reaches the following entity where the grouping should be restarted.
As follows:
| Entity Name | Stat Q | Period |
| Entity A | 2013Q2 | 1 |
| Entity A | 2013Q3 | 1 |
| Entity A | 2013Q4 | 1 |
| Entity A | 2014Q1 | 1 |
| Entity A | 2014Q2 | 2 |
| Entity A | 2014Q3 | 2 |
| Entity A | 2014Q4 | 2 |
| Entity A | 2015Q1 | 2 |
| Entity A | 2015Q2 | 3 |
| Entity B | 2014Q1 | 1 |
| Entity B | 2014Q2 | 1 |
| Entity B | 2014Q3 | 1 |
| Entity B | 2014Q4 | 1 |
| Entity B | 2015Q1 | 2 |
| Entity B | 2015Q2 | 2 |
| Entity C | 2018Q2 | 1 |
| Entity C | 2018Q3 | 1 |
| Entity C | 2018Q4 | 1 |
| Entity C | 2019Q1 | 1 |
| Entity D | 2017Q3 | 1 |
| Entity D | 2017Q4 | 1 |
I know it's a very specific question but any workaround / formula to solve this would be much appreciated.
Many thanks,
J
