Sales per product

Question

hi all,&nbsp;have two tables, one for products which contains 3 fields: Prod, Ref Prod and Non Ref Prod.Next to that table i have a table with sales data such as Quantity, Gross sales and Net Sales.Want to create a table with Ref Prod and Non Ref prod with the related sales (Quantity).currently my table looks like this:&nbsp;Ref Prod &nbsp;&nbsp; Non Ref Prod &nbsp; Quantity&nbsp;AAAR &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 15 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;BBBR &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;CCCR &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 25 &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; AAAA &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; BBBB &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 60&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; CCCC &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 100TOTAL &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 240But I want to have 1 column with the total per product type (RefProdTotal and NonRefProdTotal)any ideasthnxM&nbsp;

v-jiascu-msft · Accepted Answer

Hi&nbsp;Anonymous,&nbsp;Maybe you can use the formula below as a calculated column.&nbsp;Edit: weird! The formula is gone. I will add it anyway.Column =
IF (
    ISBLANK ( [Non Ref Prod] )
        || [Non Ref Prod] = "",
    LOOKUPVALUE ( sales[Quantity], sales[Ref Prod], [Red Prod] ),
    LOOKUPVALUE ( sales[Quantity], sales[Non Ref Prod], [Non Ref Prod] )
)&nbsp;Best Regards,Dale

Forum Discussion

Sales per product

1 Reply

Related content

need to display monthly sales and 6 month average sales for products

calculate cumulative sales for active products

Sales by Product Category

Last year products saled

Production Lessons