Forum Discussion
sum up error, same ID appear twice
Hello
did anyone encounter the same problem that same price, not sum up in one line but 2 lines.
need help how to avoid it and the logic behind.
thank you so much!
| Price | Qty |
| 0 | 90 |
| 0.25 | 1906140 |
| 0.27 | 3943096 |
| 0.27 | 250000 |
| 0.278 | 1500 |
| 0.28 | 353910 |
| 0.28 | 60 |
| 0.285 | 2500 |
| 0.29 | 258586 |
| 0.294 | 2960 |
| 0.297 | 3980 |
| 0.3 | 35520 |
| 0.308 | 200280 |
| 0.311 | 2500 |
| 0.319 | 84534 |
| 0.32 | 6300 |
| 0.393 | 98475 |
| 0.415 | 10 |
thanks for your help! it was my careless mistake!
my data (price) is 4 digits (this is not of my knowledge), and I formatted 3 digits in the visual, and I export the data to csv file, it keeps only 3 digits, thus, I thought my data is correct with only 3 digits.
anyhow, thank you for your help. and sorry about this
5 Replies
xuexi1890 Make sure that you didn't select "
Don't Summarize" under values section for that qty column.hello Pattem,
i did choose sum. the price is on the Axis and qty is on the Values.
it is quite confusing for me. i have no clue why it is acting like this.
regards
nate
Hi xuexi1890
If the issue still exist, please kindly upload it to Onedrive/Dropbox and share the download link here. that will be easier for us to check it further.
thanks for your help! it was my careless mistake!
my data (price) is 4 digits (this is not of my knowledge), and I formatted 3 digits in the visual, and I export the data to csv file, it keeps only 3 digits, thus, I thought my data is correct with only 3 digits.
anyhow, thank you for your help. and sorry about this
