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?).