Two Records getting merged in Table Visualization

[achyutmishra92]

I have two records as below which are invoices issued on same day for same customer

I can see it clearly that these are two different invoices, However when i am pushing this data in Table Visualization; I am getting below ouput where invoice numbers as well as amounts are being added as shown below

[V-lianl-msft · Accepted solution]

Hi @achyutmishra92 ,

It should be pointed out that in the table visual, if there is no column with unique value, the number values will be aggregated by default.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[HotChilli]

Looks like you are storing the invoice number as a number type, it's got a default summarization of sum (which you don't want) .  You can change the summarization in the Values well for a particular visualisation - change it to 'Don't summarize' from the dropdown.