6 Replies Latest reply: Sep 5, 2014 6:25 AM by vinaykumar HG RSS

    Total on only visible columns in straight table

    Rory Webber

      Hi All,

       

      I have a straight table in one of my apps with a column for each month. Dependant on month selections, only the selected months are displayed, using an expression in the conditional show for each column. I need to create a total column at the end of my table that shows the totals for only columns that are visible.

       

      Is there an attribute or function I can use to determine if the column is being shown, or in my total column do I need a nested if statement that essentially repeats the same conditional show logic to total the columns?

       

      I know I get this natively with a pivot table, but the business want full interactive sorting functionality on each column which I believe is lost in a pivot table (can only sort by dimensions and not expressions?).

       

      Thanks,

       

      Rory.