2 Replies Latest reply on Mar 3, 2012 8:24 AM by Teresa Obis

    I almost have a nice viz for numeric and weigthed distribution

    Teresa Obis

      I try to create a viz with the results of Numeric Distribution and Weigthed Distribution.  To compute Weigthed Distribution I have to use the following computation in order to avoid text overlaping.

       

      IF FIRST()==0 THEN

      WINDOW_SUM([Total Sales per Store],0,IIF(FIRST()==0,LAST(),0))/[Total Sales of Stores]

      END

       

      The Text computations works very well

       

      But when I try to do a viz with this data I have problems with records with cero value in Weigthed Distribution

       

       

      Does anyone help me?

       

      Find attached the workbook.

       

      Thank you,

       

      Teresa