I Have created a table view in the report, where i need to hide one column in the report?
Do we have any option to hide a column in the table view / any custom code available for that.
Hi Ralf, Thanks for the Reply.
I have a table view created with 3 Columns (ProductID,Product Name,Sales) as below.
productID ProductName Sales
00001 Soft Bread $21,334
00002 Wheat Bread $17,879
00003 Milk Bread $14,890
Where i want to hide the column (productID) in the Dashboard and the output should be like below.
Soft Bread $21,334
Wheat Bread $17,879
Milk Bread $14,890
I think a complete hide is not possible at the moment.
You have two options:
1. You can make the content invisible by setting the textcolor to white()
and the header expression to something like that - or '
2. You can use a extension like this:
but i think the second option doesn´t solve your problem because the ID is your Dimension and you must have a Dimension to use this extension
Ralf, Thanks for the inputs.
First option is also not working, as it displaying blank values to the first field with the field heading.
I dont want that column to show as nulls in the report, just want to hide it.
If only no one should see it in the first view you can change the order of your visualisations dimensions and measures and set the id at last.
In the next step you can change the column with so that noone can see the id without changing the view.
I am not sure if i am just over simplfing this, but can you not just remove the product ID column. I am assuming the Product ID and Product Name has a one to one relationship?
If not like people have suggested extension or White text a . for the Column name.
Hi Mark, Actually Whatever the column I need to hide I'm using some rank and set analysis and based on that I'm getting some text information from the different table. So Where I don't want to show the Rank column into it but need to show the text information.