As like attached pic I have two straight tables, in both the tables i have different dimensions and same expressions and am swapping rows as columns. i want to put these two tables side by side and t want to hide the expression from second table so that it looks like single table but i am not finding a way for this is there a way to hide the dimension in straight table. Please help me with the solution.
Go to properties of second chart, in presentation tab, select dimension listed above and there is an option 'Hide Column'. Your dimension will disappear.
Thanks for the replay, sry there was mistake in my post. I need to hide the expression not the dimension, please read my above query once again i have corrected my question now.
It is possible to hide expression in straight table. If you are using straight table, then apply this.
If you are using Pivot table then its not possible to hide expression. In this case you can change font color of that expression to white or similar to the background color so that expression will look disappeared.
