So, I have a straight table with a hidden column that can be shown just by clicking a button.
My problem is: is there a way to continue using the values of that column when she is hidden? Because I'm using column(1) when she is being shown so I can use her values, but when I hide her, the column(1) changes to another column.
A column hidden by Conditional expression cannot be referenced when its hidden. If you are never going to see it then you can hide it from the presentation tab (but this cannot be controlled by a button) which I think can then be referenced.
So, I have this table with these columns: Product (my dimension), Stores(my hidden column), count(Stores), avg(Sales1), avg(Sales2). When I expand the table, my hidden column appears and I can see the both avg of each product store by store, so a quick example:
product store count(store) avg(sales1) avg(sales2)
prod1 2 1 30 32
prod1 5 1 33 29
prod1 4 1 31 30
When I hide the column store, I'm not able to use 2, 5 and 4, even if I just use my expression name (which is Store), or [Store], I didn't found any way to use her.
I tried every tip you guys gave me, but I don't know why I can't use her, maybe what sunindia said is right, because I'm using a Conditional expression to hide that colum (which is also a expression).
I tried to use set analysis with column() or the name of my expression (Store, or [Store]), but I didn't manage to get it done. Is there a way to do that? I mean, use column() or expression name with set analysis?
I hope I'm more clear now and again, thanks everyone.