I have two expressions in pivot table. I am using the first expression(name) to derive the second expression...Thus, I have to enable it..
I just want to hide it and leave only the 2nd expression to show that depends on the on the 1st expression.
I tried using a conditional false()... it worked but the 2nd expression got affected. This table will be sent out to our customers and it's not good for for them to see 2 expressions in 1 dimension when they don't need the 1st. If it's not possible to hide an expression in the pivot table as stated in the community, how can I at least delete the 1st expression during Nprinting.
I could not see the rest of your image above, so I don't know how many dimension are in your pivot table. So, you are saying that your data needs to be dynamic so that the end user can interact with it after you send it to them. Do you really need a pivot table? I have several straight table charts that act like stored procedures. You create an expression that you are going to hide. You then create an expression label for that. Then you create the next expression and use the label from the first in your expression. You can keep doing this until you get to your end result and then only display the net result column.
I have 9 dimensions and 2 of the them Week no and Mon week are converted into horizontal columns...This is why I can't use the straight table but pivot only... And you are correct, I need this dynamic so the user can interact.
