6 Replies Latest reply on Mar 26, 2020 9:30 PM by Laura Ma

    How to dynamically hide other rows and keep 3rd row only?

    Laura Ma

      Hello experts,

       

      I'm trying to show T-2 data daily and hide the other rows. For example, the data shown in the report today should be 3/24/2020. I tried a few different ways but none of them worked:

      1. Right click and hide: the data source is refreshed daily with latest data. The hide cannot be updated automatically.

      2. Index: the INDEX() works fine on the state level metrics but not Grand Total calculation.

      3. Filter: it will impact the calculation.

       

      Any help would be appreciated!!! Thanks so much!!!!

      Screen Shot 2020-03-26 at 6.00.21 PM.png