sentiment score | 1 | 1 | 0.9 | 0.9 | 0.8 | 0.8 |
count | 300 | 250 | 5 | 3 | 2 | 16 |
<tbody>
</tbody>
I would like to sump up distinct values for each sentiment score to get something like this:
sentiment score | 1 | 0.9 | 0.8 |
count | 550 | 8 | 18 |
<tbody>
</tbody>
Thanks!
J
sentiment score | 1 | 1 | 0.9 | 0.9 | 0.8 | 0.8 |
count | 300 | 250 | 5 | 3 | 2 | 16 |
sentiment score | 1 | 0.9 | 0.8 |
count | 550 | 8 | 18 |
Hello,
Using the "Sentiment score" as a pivot field should do just that (sum up per value).
So if you pull the "Sentiment score" field to the column label section of the pivot table, you should be fine.
If not, it may be that your scores, although displayed as similar values, are in fact slightly different behind the comma and Excel sees them as different values (for instance, the two 0.9 score may be 0.86 and 0.87).
> In number format, try displaying additional positions behind the comma to verify this.
Cheers,
drW