Get One Dimension Value

[RishabhTFC]

Hi all,

Please help me in this

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

Item Name	Sales
Apple	250
Mango	150
Orange	300

Secone Sheet :  Contains Stock of Qty of Items:

Item Name	Qty
Apple	10
Mango	8
Orange	12
Guava	8
Melon	6

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. 

Any one help me on this please

 Thanks

RM

[Ezirraffner]

Hi @RishabhTFC ,

Is this the expected result?

Item Name	Sales	Qty
Apple	250	10
Mango	150	8
Orange	300	12

For this...

LOAD *
[...First Sheet]

INNER JOIN

LOAD *
[...Second Sheet]

Best regards,

Ezir