topic Re: How to hide columns depending of the columns names / Pivot table ? in App Development

How to hide columns depending of the columns names / Pivot table ?

hub — Wed, 07 Sep 2022 15:12:31 GMT

Hello,

Anyone knows how to do that ?

I'm trying to mask or show the month depending of the year (show the month split for the current year but only show the total for next year). I guess that it can be done with a condition somewhere...

My columns has 2 fields "Year" and "Month", so I'm trying to customize the month field with "show column only if" but with no luck...

Any idea ?

Result expected :

Columns fields for the pivot :

Settings of the "Months" columns, with total and trying to customize the "show the columns only if"....

thanks !

Re: How to hide columns depending of the columns names / Pivot table ?

vinieme12 — Thu, 08 Sep 2022 07:14:16 GMT

the show/hide condition will hide the entire dimension not values

You need to use a Calculated Dimension as below

Dim1: =Yearfield

Dim2: =Aggr(if(Yearfield=Year(Today()),Monthfield,'TOTAL'),Yearfield,Monthfield)

Re: How to hide columns depending of the columns names / Pivot table ?

hub — Tue, 13 Sep 2022 14:06:40 GMT

Hey Vineeth, thanks !

Sorry I didn't had a chance to review your answer before.

I just tested it and it works well, but now, I would like to hide the multiple "0" columns which makes no sense in that context : for example in the A22 columsn (which means actuals 2022) having the month is excellent; however I would like to hide 2023/2024/2025.

As I have several values, it duplicated uneeded columns without content...

any idea how to fix that ?

thanks for your great support !

"Year-Month" syntax :

=aggr(if(YearField<year(today())+1,MonthField & ' ' & YearFiled, YearField), YearField, MonthField)

Re: How to hide columns depending of the columns names / Pivot table ?

vinieme12 — Wed, 14 Sep 2022 06:13:23 GMT

Change to below

"Year-Month" syntax :

=aggr(if(YearField<year(today())+1,MonthField & ' ' & YearFiled, '-'), YearField, MonthField)

Also under Add-Ons >> Data Handling >> Uncheck include zero values

Re: How to hide columns depending of the columns names / Pivot table ?

hub — Wed, 14 Sep 2022 16:18:45 GMT

Hello, thanks, I tried that & different combinations, it's still the same...

thanks for your help anyway