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)
