5 Replies Latest reply on Mar 12, 2019 12:43 PM by sindhu gullapalli

    Count of values table acorss and table down

    sindhu gullapalli

      Hi Team,

       

      I have a requirement, where i want to show the count for complant reason cateogry and product category.

       

      so i need to calculate to show the top 5 from both and rest in "All other" Category, i have calculated with parameter and calculated fields help.

      as a separate if i am showing product count and reason count its showing perfect.

      but when i am trying to count both at the same time, for All others its not giving the right values either its hiding row wise or column wise.

       

      i cant attach the workbook, hence attaching the screen shots.

      please help me , how to resolve this

       

      Table across

      Table down

      calculated filed i am using

       

      IF ([(Calc) In top n]) THEN

          (COUNTD([Case Id]))

      ELSEIF [Show all Products] THEN

         (COUNTD([Case Id]))

      ELSEIF ([(Calc) Others]) THEN

          WINDOW_SUM((COUNTD([Case Id])), 0, last())

      ELSE

          NULL

      END

       

      Actual count

       

      Thanks in Advance!!