I Need All Dimension Values in Straight Table

[azimabadi]

Hi all,

please consider the following tables :

T1

___________

F1   F2    F3

1     A     A10

2     A     A20

3     B     B10

4     B     B20

5     B     B30

T2

_______

F1   F4

1     5

1     10

3     12

3     17

5     20

5     7

5     4

then i have a Straight Table Chart with F2 & F3 as dimensions and sum(F4) as expression. the result is :

A     A10     15

B     B10     29

B     B30     31

and it is what we excpect from a straight table. but i need the result with all F2 & F3 values. My result sould look like:

A     A10     15

A     A20     0

B     B10     29

B     B20     0

B     B30     31

the sample qvw with above data and chart is attached. Thank you forward for any help or idea.

Best Regards

Peyman

[Jason_Michaelides]

Can't open the app at the moment but try unchecking "Supress zero value" I'm the presentation tab. You may also need to check Show All Values on the dimension tab.

Hope this helps,

Jason

[azimabadi]

Hi Jason, Thank you for answer.

I have tried all options, but i can't get the answer i need !

[Jason_Michaelides]

Works for me.  See attached.

[azimabadi]

You are right! But i did the same and get another result. can you please check my qvw againe and see if i have made something wrong?

[Jason_Michaelides · Accepted solution]

You haven't unchecked the "Suppress Zero Values" in the presentation tab like I said to do.

[azimabadi]

Thank you so much Jason!

All the Best

Peyman

[azimabadi]

now there is another problem !

please consider the following qvw, is there anyway that i can show the result in bottom table as in above?

[azimabadi]

i post the question again as a new discussion, becuse this one is marked as answerd.