Identical rows

[Vikash2024]

I have a table that have identical rows so how to handle the identical rows without losing the data.

My Query is when I create a KPI it will take only one value from that identical rows  But i need all the value.
How to handle this type of problem?

[Vikash2024]

In the images that I shared with you. I loaded both the tables in Qlik sense. and compare when i take the KPI's for specific Invoice_no_  = 001 then
sum(Item Net Amount) = 5400 in Table1 
But When I will take Sum(Item Net Amount) in Table2. It will show me 9000.
My question is that when I took filter of Inovice_no_ = INV001. then in the both table of Sum(Item Net Amount) would be the same 5400. 

[Vikash2024]

In the images that I shared with you. I loaded both the tables in Qlik sense. and compare when i take the KPI's for specific Invoice_no_  = 001 then
sum(Item Net Amount) = 5400 in Table1 
But When I will take Sum(Item Net Amount) in Table2. It will show me 9000.
My question is that when I took filter of Inovice_no_ = INV001. then in the both table of Sum(Item Net Amount) would be the same 5400.