nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to hide a column when value is 0 which uses column grouping

Migrateduser

Hi ,
 
 I have a report which uses column grouping.I need to hide a column when value is 0.
 
I have attached sample report.
 
In this,column B is splitted by column grouping as B1,B2,B3,B4.The row for B column is aggregation.
I used labels instead of crosstab to split B column.but i can't hide a column when no value for any column of B..B has all 4(B1,B2,B3,B4) value on some scenario & has any 2(B2,B3) or 3 (B1,B3,B4) value on other scenario.How to hide a column when no value ?.I tried visibility functionality to hide a column,but it doesnot work for me.Is any other option to solve that?
 
 
Thanks,
Emy

Find more posts tagged with

Comments

There are no comments yet