I'm learning how to use the power pivot - which is an extraordinary improvement on normal pivottables. But I don't know the full capabilities. My challenge is this:
I have data arranged as follows (the real data is more complex):
<tbody>
</tbody>
The output I would like to achieve would be:
<tbody>
</tbody>
I think that PowerPivot could do something like this, but can't work out how. If someone let me know, authoratitivly, whether to persist with PP or whether I need to take a different approach I'd be grateful.
Many thanks
Peter
I have data arranged as follows (the real data is more complex):
Activity | Start Date | End Date | Total Effort |
A | 1 Jan 2018 | 31 Dec 2018 | 60 |
B | 1 Mar 2018 | 30 Sep 2018 | 140 |
C | 1 Aug 2018 | 31 Dec 2018 | 100 |
<tbody>
</tbody>
The output I would like to achieve would be:
J | F | M | A | M | J | J | A | S | O | N | D | |
Effort | 5 | 5 | 25 | 25 | 25 | 25 | 25 | 45 | 45 | 25 | 25 | 25 |
<tbody>
</tbody>
I think that PowerPivot could do something like this, but can't work out how. If someone let me know, authoratitivly, whether to persist with PP or whether I need to take a different approach I'd be grateful.
Many thanks
Peter