5 Replies Latest reply: May 30, 2012 2:36 AM by Ashutosh Paliwal

# How to show Dimension values that are excluded by selection with 0 as expression value??

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 :

F2     F3     sum(F4)

A        A10     15

A        A20     0

B        B10     29

B        B20     0

B        B30     31

i need to have all values in F2 and F3, so i checked "Show All Values" for F3 and i get two rows with 0 for sum(F4).

but when i make a selection on F4, for example "17" the table shows like this:

F2     F3     sum(F4)

B        B10     17

-         A10      0

-         A20      0

-         B20      0

-         B30      0

the result is logical, but as a customer need, i have to show the result as below:

F2     F3     sum(F4)

A       A10      0

A       A20      0

B       B10     17

B       B20     0

B       B30     0

the sample qwv is attached with data and two straight tables in different states. i appreciate any help.

Best Regards

Peyman

• ###### How to show Dimension values that are excluded by selection with 0 as expression value??

any idea?!

• ###### Re: How to show Dimension values that are excluded by selection with 0 as expression value??

You can make one more expression and using set analysis make it unaffected by selections and then hide that column.

Let me know, if any issue!

..

Ashutosh

• ###### Re: How to show Dimension values that are excluded by selection with 0 as expression value??

Hi Ashutosh,

the example runs good and it looks to be the right way to do this. Thank you so much for answer. I will apply the method to my app and tell you the result.

Best Regards

Peyman

• ###### How to show Dimension values that are excluded by selection with 0 as expression value??

Hi Ashutosh,

i want to say that the method works good in my app and Thank you againe for your help.

Best Regards

Peyman

• ###### How to show Dimension values that are excluded by selection with 0 as expression value??

Thanks Peyman!

Best Regards,

Ashutosh