Duplicate data in my report

Hi,

I have an appsheet app where i can enter delivery order, material and price.

Sometimes, one delivery order will have 2 different material. So, i will need to enter the data twice with the same delivery order number but different material and different price.

In my summary report,i have 2 columns which are delivery order and total price. Thus, I only wants to show one delivery order number with the total price of 2 different material.

With my current setup, it will show 2 same delivery order number with 2 different price in my report.

How do i solve this?

0 4 425
4 REPLIES 4
Top Labels in this Space