Ability to hide/suppress columns if null based on the prompt selection

Dhamu

Description

We are trying to create a pivot view in BI Analysis, which is having a set of columns that will either return null or values based on prompt selections. The ability to suppress the columns when it is null instead of showing entire column as empty would be better understandable especially working with many number of columns.

Use Case and Business Need

 

My pivot view has columns A,B and C (attribute) and X (measure).

Consider having pivot with A and B in rows section and C in columns section with X in measures section, based on the prompt selections B might return null in some cases and we need to dynamically suppress B in pivot view.

Original Idea Number: 679bee9a1e