1 Reply Latest reply on Jun 11, 2013 10:32 AM by Shawn Wallwork

    Table calculation with TOP N parameter in Waterfall

    Ajit Kumar

      Hi,

       

      I am facing a problem in order to create a waterfall chart with TOP N parameter.

       

      I have explained the problem definition in the attached workbook in caption.

       

      Please provide me help on this

       

      Thanks

       

      Ajit

        • 1. Re: Table calculation with TOP N parameter in Waterfall
          Shawn Wallwork

          Ajit, the reason the figure is changing is because your table calculation is being computed using GlobalCustomerName, so when you eliminate some customers, Tableau recalculates. Essentially T is doing what you're asking it to do.

           

          BTW, you really don't need all those ((((())))), nor do you need the ROUND() functions. This works just fine:

           

          if (98-([OSA%]*100))* Sum([StockedList])/Total(Sum([StockedList])) < 0

          then 0

          else

          (98-([OSA%]*100))* Sum([StockedList])/Total(Sum([StockedList]))

          End

           

          Cheers,

           

          --Shawn