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

    Dynamically display subtotal

    Dale Wunderlich


      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.


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



      CASE [showCounties]

      WHEN "yes" THEN [CountyName]

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