Question about hiding rows so they do not come though onto a dashboard

Trav25

Hi there,

As per the image below I have columns that display the month from Left to Right. I am looking to hide the months closest to the primary column as they are now in the past - but want to copy the primary column as is displays the metrics on my dashboard. Can I simply hide the rows I don't want or is there another solution??

Any help would be amazing

Thanks,

Trav

Kaveri Vipat

Hello @Trav25,

If you want you can hide the columns and it will not affect any calculations.

Matt Johnson

Hi @Trav25

I would create a report for this information and display the report on the dashboard. While you could publish the sheet and display that on the dashboard, the report is the safer way to go.

I hope that helps.

Matt