1 Reply Latest reply on Jun 7, 2017 3:35 PM by Patrick A Van Der Hyde

    How to get a formula to be fixed for overall but include months.

    Alex Martino

      I have a line chart broken down by category and months. How can I get the total OVERALL  amount  (ignore Channel) to show for each channel but to include months? This is what I have so far but it doesn't work.

       

      {FIXED [Channel] : IF [Metric]='Closings' THEN [YTD Closings Change]

      ELSEIF [Metric] = 'Average Premium' THEN [YTD Average Premium Growth ]

      ELSEIF [Metric] = 'Written Premium' THEN [YTD Premiums Change ]

      END}