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 for your response.
That gives me a total at the top of the column, I'm looking for a total at the end of the row for the columns that are visible in that row:
Jan Feb Mar Total
1 2 5 8
That gives me the total of all the month columns in the table - irrespective of if they are visible or not.
But if I've hidden any of the columns using a condition on the Presentation tab, then I what I want to see is the total of only the visible columns.