3 Replies Latest reply on Mar 28, 2012 9:47 AM by Jonathan Drummey

    Use table calculation in a calculation

    Allison Suarez

      I have a pareto chart showing Percent of Total table calculation.  I want my users to be able to choose a certain percentage to view (80% or 90% etc).  I am trying to use a parameter because the filter on the dashboard takes forever.  However I need to use the paramter in a calculation that is in the view in order for it to work as a filter on the dashboard.  My thought was to use the CASE calculation with set values.  So it would be

      CASE [PercentageSelector]

      when "80" then (table calculation for top 80% of values)

      when "90" then (table calculation for top 90% of values)

       

      Can anyone help me figure this out?