Dynamic year selection in a grid

Hi ​@Chahat,

One approach would be to filter the timeframe directly in the formula, by restricting it to FY25 and FY26, and then hide blank rows and columns in the view.

This might require duplicating some metrics specifically for this view, especially if the full time range is still needed for downstream calculations, which may not be ideal if this applies to several metrics

How many metrics would need this logic applied?

Thanks!

Hey ​@Julie Guérin ,

There are total 9 metrics in the table:
2 input metrics should have the column header “FY26”;

Formulated metrics:
3 metrics should have the column header “FY 25”
4 metrics should have the column header “FY 26”
By applying ‘Hide empty rows and columns’ , it is getting applied to all the metrics in the table, (including input metrics).

But, 2 input metrics should have the column header “FY26”;
and there are some blank cells in these input metrics within FY26 which needs to be shown as well. (even if blank)

Hey ​@Chahat, 

Edited: Actually it won’t work as it’s hiding for all metrics.

Would using the “Hide item” option from the FY column dropdown work better for your use case? It won’t be dynamic though. 

Thanks!

By using the “Hide item” , it’s getting applied to all the metrics within the same table (even if ‘Hide Item’ is done on just 1 metric through FY column dropdown)

But, it should be applied on “certain metrics” only