How to make cell level formulae work for Zoomed-In column-cells
Calculations/Formulas for Zoomed-In column-cells
Formulas on quarters not working for month columns when user zooms-in the QTR (some formulas refer same column but many are referring different columns/another grid as well). Is there a way to make these calculations work for the zoomed-in column-cells as well?
Also we have a variance section of the quarters and users are asking for zoom-in there as well to see monthly variance. Is it possible to apply zoom-in on formula columns?
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):