1 Reply Latest reply on Dec 6, 2016 2:52 AM by lenaic.ridinger

    Add data across worksheets

    Jitu Raj Bora

      Hello,

       

      i have 2 worksheets - called GL 8001 and GL 8003. These 2 worksheets use the same logic, just different filter and parameter values. Now, the result from GL 8001 is stored in a Calculated field called NewItemValue8001. Similarly, the result from GL 8003 is stored in a Calculated field called NewItemValue8003.

       

      I want to have a Grandtotal Worksheet that adds NewItemValue8001 and NewItemValue8003 (and more worksheets if there are any).

       

      Is this possible? Ideally, i would want the Grand Total to reflect any changes that are made to the 'constituent worksheets'