Forum Discussion
Solved
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....
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
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