sum up error, same ID appear twice

[xuexi1890]

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

[v-diye-msft]

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.

[xuexi1890 · Accepted solution]

@v-diye-msft @PattemManohar 

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

[PattemManohar]

@xuexi1890 Make sure that you didn't select "Don't Summarize" under values section for that qty column.

[xuexi1890]

@PattemManohar 

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

[PattemManohar]

@xuexi1890  Please try changing the x-axis as "Categorical" under Format Section.