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

[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 :

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

[azimabadi]

any idea?!

[#3 · Accepted solution]

Hi Peyman Azimabadi,

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

Please find the attached app.

Let me know, if any issue!

..

Ashutosh

[azimabadi]

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

[azimabadi]

Hi Ashutosh,

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

Best Regards

Peyman

[#6]

Thanks Peyman!

Best Regards,

Ashutosh