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.