Hi,
I currently have a pivot table with various conditions as rows, and revenue split out by weeks as the columns but I need to group the columns into months - is this possible? At the moment its just summing the weeks.....
<tbody>
</tbody>
Many thanks!
I currently have a pivot table with various conditions as rows, and revenue split out by weeks as the columns but I need to group the columns into months - is this possible? At the moment its just summing the weeks.....
Row Labels | Sum of 21/01/2013 | Sum of 04/02/2013 | Sum of 28/01/2013 |
Company A | |||
Revenue Type X | 0 | 45.16129032 | 19.08602151 |
Sale Description 2 | 0 | 45.16129032 | 19.08602151 |
Sale Description 1 | |||
0 | 0 | 45.16129032 | 19.08602151 |
Revenue Type Y | 196.1890244 | 405.4878049 | 304.4461382 |
Sale Description 2 | 0 | 175 | 73.95833333 |
Sale Description 1 | |||
0 | 0 | 175 | 73.95833333 |
Sale Description 2 | 32.69817073 | 38.41463415 | 38.41463415 |
Sale Description 1 |
<tbody>
</tbody>
Many thanks!