Hi all;
I have a simple power pivot report with two tables (Table1 and Table2 below) connected by the field "Item".
I need to create a calculated column in the Table2 called "StoreB_Quantity" that shows the quantity the store B has of a certain product. I tried using the RELATED and FILTER functions together but could not put both working to show the results listed in the Table2.
How would the formula be under StoreB_Quantity below to show those results?
Thanks.
Table1:
<tbody>
</tbody>
Table2:
<tbody>
</tbody>
I have a simple power pivot report with two tables (Table1 and Table2 below) connected by the field "Item".
I need to create a calculated column in the Table2 called "StoreB_Quantity" that shows the quantity the store B has of a certain product. I tried using the RELATED and FILTER functions together but could not put both working to show the results listed in the Table2.
How would the formula be under StoreB_Quantity below to show those results?
Thanks.
Table1:
Store | Item | Quantity |
A | Banana | 2 |
B | Banana | 5 |
C | Banana | 8 |
D | Banana | 1 |
A | Melon | 0 |
B | Melon | 3 |
C | Melon | 6 |
D | Melon | 4 |
A | Apple | 12 |
B | Apple | 7 |
C | Apple | 9 |
D | Apple | 2 |
<tbody>
</tbody>
Table2:
Item | StoreB_Quantity |
Banana | 5 |
Melon | 3 |
Apple | 7 |
<tbody>
</tbody>