2 Replies Latest reply on Sep 13, 2012 2:18 PM by Dale Wunderlich

    Dynamically display subtotal

    Dale Wunderlich

      Hi,

      Is there a way to suppress subtotals or hide (collapse) constituent values. I would like to show totals only when the user has selected to see all the county data.

      showCounties.PNG

      as you can here, the table aggregates alright when I use the code below but the "total of total" is not necessary

      onlyTotal.PNG

       

      CASE [showCounties]

      WHEN "yes" THEN [CountyName]

      WHEN "no" THEN "Total" // if I comment this line out I just get null instead of Total

      END