Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Could you help me to solve some modeling data problem please?
I have 2 tables:
Product:
load * inline
[PID
x1
x2
x3
x4
x5];
Stock:
Load * inline
[PID, qty, warehouse
x1,1,A
x1,2,B
x3,1,A
x3,8,B
x5,6,C];
The output is pivot table
PID | sum(qty) |
x1 | 3 |
x2 | 0 |
x3 | 9 |
x4 | 0 |
x5 | 6 |
when i use selection field "warehouse" and select i.e. A
Tables shows only
PID | sum(qty) |
x1 | 1 |
x3 | 1 |
how can I keep view frozen (all PID always displayed)
I would like to achieve something like this
When selecting warehouse A
PID | sum(qty) |
x1 | 1 |
x2 | 0 |
x3 | 1 |
x4 | 0 |
x5 | 0 |
Hi Waszcma
I think there is a simple solution to this. In the presentation tab if you uncheck 'Suppress zero values' and 'Suppress missing' that should do the trick.
Have a look at the attached and if I understood your question right this should work.
Thanks
CJ
Hi
I need some clarification in the question - You need to achieve like if you select warehouse A
In the table it should show all PID's not only X1 and X3 which belongs to only A. Is that you want to achieve. Help me if I am wrong in understanding your question.
X1 1
X2 0
X3 1 ..
Exactly as you wrote
After selecting warehouse A QV will display table with only 2 rows, PID (x1, x3) but other rows which refering to x2,x4,x5 will gone.
I would like to keep the table view always with 5 rows PID(x1, x2, x3, x4, x5) but after selecting A
it should calculate qty only for x1 and x3, others qty should be 0
Hi Waszcma
I think there is a simple solution to this. In the presentation tab if you uncheck 'Suppress zero values' and 'Suppress missing' that should do the trick.
Have a look at the attached and if I understood your question right this should work.
Thanks
CJ
This is exactly what I need but there is still something odd.
I copied the table to my app and it works but when I checking second table i cant uncheck Suppress missing
on your table it is unselected? I dont know why in my application i cant change this option in properties?
Finally I have found the reason
In my table under Chart properties -> Dimensions i should tick Show All Values
Thank you for your help!