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

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

    Peyman 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