Forum Discussion
Sum values based on distinct ID, group by another column
Hi Everyone. I need some help:
I am trying to display a pie chart, of grouped and sum values based on a distinct ID
My data looks like this:
ID | Amount | Code |
1 | 220 | G |
1 | 220 |
|
2 | 350 | F |
2 | 350 |
|
2 | 350 |
|
3 | 125 | G |
3 | 125 |
|
4 | 220 | F |
4 | 220 |
|
Currently, I am using filters and sum measures but my results are summing every value, not the one value based on the ID. My current results are as so:
Total Sum = 2180
Group G: Sum = 690
Group F: Sum = 1490
Which is incorrect, as it is summing every value.
I need my results to be:
Total Sum = 915
Group G: Sum = 345
Group F: Sum = 570
As I am trying to display these groups in a pie chart.
Anyone have a fix for this? Thanks in advance
