7 Replies Latest reply on Jan 23, 2018 12:09 AM by Niranjan Banarjee

    Unable to get the Table(Down) option

    Niranjan Banarjee

      Hi,

       

      I am trying to calculate Share in the below view, but its is not displaying the  compute using Table (Down) option..

       

      Rolling Forecast =

      WINDOW_SUM(SUM([Measurements]),

      CASE [Rolling Data Type]

      WHEN "MTD" THEN 0

      WHEN "R3M" THEN -2

      WHEN "R6M" THEN -5

      WHEN "R12M" THEN -11

      WHEN "YTD" THEN (-[YTD Indicator-CY]+1)

      END

      , 0)

       

      Requirement= Rolling Forecast/Total(Rolling Forecast) , but it is also not allowing the following error erupts.