Sianny2164
New Member
- Joined
- Nov 14, 2016
- Messages
- 1
Hi,
I work in marketing and am struggling with being able to do a pivot table due to the large number of fields and different titles. However l know what l want my end point to be. I have streams of data like the below and am basically wanting to be able to set thresholds to form the business rules for an email framework.
I want to be able to see it on a graph that a bunch of contributors have earned between £100-£200 in this month and £200-£500. Can anyone help? Am l looking at it the wrong way?
<colgroup><col><col span="12"></colgroup><tbody>
</tbody>
I work in marketing and am struggling with being able to do a pivot table due to the large number of fields and different titles. However l know what l want my end point to be. I have streams of data like the below and am basically wanting to be able to set thresholds to form the business rules for an email framework.
I want to be able to see it on a graph that a bunch of contributors have earned between £100-£200 in this month and £200-£500. Can anyone help? Am l looking at it the wrong way?
Contributor | Nov-13 | Dec-13 | Jan-14 | Feb-14 | Mar-14 | Apr-14 | May-14 | Jun-14 | Jul-14 | Aug-14 | Sep-14 | Oct-14 |
Contributor 1 | £0.00 | £0.00 | £0.00 | £0.00 | £180.00 | £0.00 | £110.00 | £0.00 | £43.05 | £0.00 | £0.00 | £11.16 |
Contributor 2 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 |
Contributor 3 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 |
<colgroup><col><col span="12"></colgroup><tbody>
</tbody>