Charting

Charting

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

  • 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.

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In