Sales per product

[emveha]

hi all,

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:

Ref Prod    Non Ref Prod   Quantity 

AAAR                                        15                 

BBBR                                         20               

CCCR                                        25      

                       AAAA                 20

                       BBBB                  60

                       CCCC                100

TOTAL                                      240

But I want to have 1 column with the total per product type (RefProdTotal and NonRefProdTotal)

any ideas

thnx

M

[v-jiascu-msft · Accepted solution]

Hi @emveha,

Maybe you can use the formula below as a calculated column.

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] )
)

Best Regards,

Dale