3 Replies Latest reply on Jan 31, 2019 8:21 AM by David Matthews

    How to carry a calculated field value across worksheets with seperate unrelated datasources

    David Matthews

      Hello and thanks in advance for any advice.

       

      Due to the data being at different levels of detail I have had to use different unrelated datasources across worksheets. I need to use a calculated field value from sheet 1 on Sheet 2 which uses a separate unrelated custom sql to get data. So on sheet 2 I need:

       

      Value from Sheet 2/Value from Sheet 1 calculated field.

       

      Any idea if this can be done?

       

      Also I'm not looking to use a filter across sheets. I know how to and am using one. I need to know how to bring a value from a calculated field to another unrelated datasource sheet.

       

      Thanks again.