Im unable to set Filter condition on aggregate measure - Tableau desktop 10.3

tableaucommunity@tableau.com — Thu, 15 Feb 2018 20:42:25 GMT

I am trying to create a List report in Tableau 10.3 need the functionality of being able to Hide/Unhide columns so that the report size can shrink/unshrink. I do not just want to display Null. The report has the following aggregate measures:

Let’s use the first measure to analyse the problem as others measures are similar.

Values for the measures are determined based on parameters. The intention is to display Null to hide the column when “POS Hide” is selected. This is working fine based on the calculated column below for all the measures. Sample below.

However, I want to go a step further to Hide the entire entire column by collapsing it - including the header - (to save report space, not just display Null).

I tried to create a filter on the measure and select `non-null values` to effect this Hide/Show column Tableau functionality.

The measure I am trying to hide is using ``Show TY POS`` has the following calculation:

I am getting errors. Can anyone help with how I can implement this filter on the aggregate measure? I am unable to add the workbook due to confidentiality.

Content in Tableau Community Forums

Im unable to set Filter condition on aggregate measure - Tableau desktop 10.3