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

Hey ​@Chahat,

Another approach would be duplicating the metrics in the view and leverage the Subset feature by replacing the Year dimension in their structures with the appropriate year subset.

This allows you to display the empty input metric without needing to hide empty rows or columns, and should help you achieve the layout you’re looking for.

Make sure to review the documentation on how to properly use subsets, especially for input metrics. Be aware that unticking the subset boolean can result in losing manual inputs.

In addition, you could submit a product idea to enhance the Hide item functionality, so it can be applied to specific metrics rather than all metrics in the view.

Hope this helps!

Great workaround ​@Julie Guérin, regarding the idea, one was already submitted by ​@Chloé