9 Replies Latest reply: Jan 20, 2013 8:12 PM by lareina.zhang RSS

    Suppress the expressions with null value

      Hi Everyone,


      I have a question here.

      I created a Report Dimension, a Report Metric and a Virtual Dates which is also used as dimension. They look like below:

      Dimension Key, Dimension

      01, Product Code

      02, Product Name



      Metric Key, Metric

      01, Sales Amount

      02, Sales Units


      Virtual Dates Key, Virtual Dates

      01, MTD

      02, YTD



      When selecting a single virtual date (MTD), dimension (Product Code) and metric(Sales Amount), the calculation is correct. I got something like

      Product Code  MTD

      101                 $500

      102                 $450


      But when selecting multiple virtual dates (MTD and YTD), I got the result as below:

                             MTD Sales Amount          YTD Sales Amount

      Product Code   MTD          YTD                MTD        YTD

      101                 $500            -                    -             $3500

      102                 $450            -                    -             $3750



      I want to suppress those fields with the '-' symble. Does anyone have any idea how I can do that?


      Thanks in advance,