Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
Ich have a central stock and a few other stocks which are all supplied by the central stock. In a table for each stock all articles with quantity is listed.
In my app I want to visualize a table where I have the list of articles with the stock the article is available in and the quantity of the article in this stock. In addition I want to have a column where the quantity of the central stock of this article is listed.
Is there a way to select the quantity of the central stock only in a measure of this table? I don't want to select it via subquery in loading script, because it increases the loading time massively and I don't have any option to edit the database.
Example:
Article | Stock | Quantity | Quantity Central Stock |
Book A | Berlin | 3 | 10 |
Book A | London | 5 | 10 |
Book B | Berlin | 10 | 20 |
Book A | Central Stock | 10 | 10 |
Book B | Central Stock | 20 | 20 |
Thank you in advance!
Did you try Set Analysis?
Sum({<Stock={'Central Stock'}>} Quantity)
Sure, but then only the rows where Stock = Central Stock have nonzero quantities in column "quantity central stock"
Great, that's what I was looking for. Thank you JuanGerardo!