How to hide columns in table report which are not having any values

Hello Team,

I have a requirement in the table chart where columns are months like Jan, Feb,Mar,.. , Nov, Dec.

I need to hide column months which are not having any values inside it

Answers

  • Jessica
    Jessica Contributor

    If you reconfigure the data so that each record/row for each month and value is independent, you would have a “Value” Column and a "MonthShortName" column, you could use the Pivot table option and then put the month as a column and it would skip the months that are not present.