How to freeze dimensions

[waszcma1]

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

[Pujitha]

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 ..

[waszcma1]

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 

[chakshu_jain · Accepted solution]

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

[waszcma1]

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?

[waszcma1]

Finally I have found the reason

In my table under Chart properties -> Dimensions i should tick Show All Values

Thank you for your help!