1 Reply Latest reply on Nov 20, 2018 8:15 AM by Joe Oppelt

    Analysing results of a worksheet in a separate sheet

    Adam Sanders
    Adam Sanders Nov 20, 2018 7:02 AM

      Basically, if I have a worksheet that has final results I want to analyze, is there a way to create a new sheet to analyze the results?

       

      IE I want to create a table that shows sum of column A, column B, column C from the worksheet A.

       

      I get I can look at different sheets in a dashboard but it still doesnt give me the ability to run analysis on a sheet

       

      Thanks

      • 34 Views
      • Categories: Calculations, Views & Dashboards
      • Tags:
        • 1. Re: Analysing results of a worksheet in a separate sheet
          Joe Oppelt
          Joe Oppelt Ambassador Nov 20, 2018 8:15 AM (in response to Adam Sanders)

          Everything you use in Sheet-B has to be generated in Sheet-B.  We don't pass measure results from sheet to sheet.  (We CAN pass dimension values through a filter action.)

           

          The best way I've found to generate values from Sheet-A in Sheet-B is to make the filters from Sheet-A apply to Sheet-B.  Use the same calcs, etc.  You don't have to shape Sheet-B like Sheet-A.  Just have the same dimensions on Sheet-B, even if they are just on the Details shelf.