Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey,
I have a table that shows item sales by store.
I want to add a column that showing the inventory of the sold item for all stores and not only for the specific store that the row is related with. how do i do that?
this is the measure right now:
NUM(
$(vInventoryLastKnownBalance)
,'#,##0')
It's showing a result only for the store the row is related with.
Hello @YarinInbar ,
Use Total in your set expression. eg
sum( Total sold)
Or show the expression behind the variable.
I have been assuming that you are looking something like below.
=sum({1} Total Sales) this will work for you.
I tried =sum({1} Total [Inventory QTY]) and the result I get is not correct 😣
Can you please share your chart or table structure.
It's something like that:
STORE | ITEM UPC | SALES QTY | CUREENT ITEM INVENTORY IN THIS STORE | CURRENT ITEM INVENTORY IN ALL STORES |
STORE 1 | 12345 | 1 | 0 | 16 |
STORE 2 | 12345 | 1 | 5 | 16 |
STORE 3 | 12345 | 1 | 1 | 16 |
STORE 4 | 12345 | 1 | 2 | 16 |
I want the last column to show the current inventory in all of the stores, even if they are not shown on the table (because they didn't sell the item in current date selection).
I have a field that bringing the current inventory for the item, I just want to know how to "disconnect" it from the stores on the table and "connect" it to the upc - so It'll tell the inventory by upc and not by store.
Hi @YarinInbar ,
With the above requirement, I will suggest that create a summarise UPC table like
ITEM UPC, sum or Count inventory
and you can join the table to the main table with ITEM UPC field.
Thank you, can you explain how do I join the table?
Hi @YarinInbar ,
Can you please share sample data, so that I can explain you on the same dataset.