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]



      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,