Dynamically hide a column

Question

Hi,

I have a requirement where I have some metrics columns as well as attributes and I have created a pivot layout after applying the necessary filters.

Now I want to hide some columns dynamically if it does not have any data. is this possible out of the box.

I have put a attribute in a section so the pivot report has got lets say 4 sections. In this some columns have values in one section but is null in the other section.

My requirement is to hide these null columns dynamically.

Thanks in advance.

[Deleted User] · Answer

Within a view using section this will not be possible as the rendering is fully dynamic. What you ask for isn't possible.

Remember that you are doing analytics and not pixel-perfect reporting. That's why there is an own product called BI Publisher which does that.

User_BX73H · Answer

Hi Joel,

Thanks for the reply. My question was more related to dynamically hide the columns.

Pivot table By Section:

Section1Attr 1Attr 2Attr 3Attr 4Measure Col1Measure Col2section2Attr 1Attr 2Attr 3Measure Col1Measure Col3Measure Col4Section 3Attr1Attr3Measure Col1Measure Col4

Joel Acha · Answer

One way to achieve this is to create 2 compound layouts; one with the column and one without the column in the same analysis. 
The second step would be to create a dashboard with 2 sections that have conditions on them. The first condition would be a count of the column > 0 for the compound layout with the column and the 2nd condition would be a count of the column = 0 for the compound layout without the column.