6 Replies Latest reply on Jul 20, 2018 6:33 AM by Divya Arya

    Dynamically Hide New Rows created by SQL Server without affecting calculations

    Divya Arya

      Hi Everyone,

       

      I've created calculated fields for Revenue Share, and I have the revenue for each company through different product lines and quarters from the SQL server. In order to make the calculation, I've had to hide the companies I don't need to be visualized, and just kept the ones I need to see. But when the new data is entered into SQL, and some new companies are added, I will have to manually update the workbook, and I have 17 workbooks right now so I can't do that. Is there any way to dynamically hide rows without using the filter function?

       

      Thanks in advance.