I am trying to get the Sum(sales) and Sum(Qty) of Dimensions of one sheet:
- I have two sheets :
First Sheet : Contains Sales of Items(No. of Items can be x Amount) :
Secone Sheet : Contains Stock of Qty of Items:
When I Load the Sheet the Item Name the two sheets connected with a unique key i.e. Item Name.
Now I want the Output table to show Sum(sales) and sum(Qty) of each respective item but do not want the item of Second sheet in my Dimension I just want the Data of First sheet only but the item name is now unique so it shows all the value of that dimensions.