Stock Store and Stock DC

[yurgelmartina]

hic‌,

Could you please help me in this issue?

I have a Table with Stock Store and Stock Distribution Center.

Each distribution center supplies a group of stores.

When I put in a pivot table the sum(StockStore) seems ok, but the sum(StockDC) comes with duplicate values.

Is there any way there I can have only 1 value of this field.

Key is:

CODCD (ehich is the DC)

STORELOCATION (which is the store),

SKU(which is the product)

Date (date of position of the stock)

[vishsaggi]

Did you try like

= Sum(DISTINCT StockDC)