2 Replies Latest reply on Jul 22, 2019 10:16 AM by Arjun Srinivasa Murthy

    Table Calculation across different Cross Tabs

    Arjun Srinivasa Murthy

      Hi, Guys, I am trying to make a marketing funnel.

      I am running into a challenge, I want to subtract (MQL - SAL) -( SQL ) all by quarter year

      i.e., ( 313 - 139 -124 )

      each is a cross tab value and in different sheets how do I achieve it?

       

      Message was edited by: Arjun Srinivasa Murthy - > Updated the Workbook TWBX ( Contain Data and Sheets)

        • 1. Re: Table Calculation
          Deepak Rai

          Please Create the views. Your Workbook just contains data. It would be difficult for anyone to start from Scratch to help you.

          Thanks

          Deepak

          • 2. Re: Table Calculation across different Cross Tabs
            Jim Dehner

            Good morning

            could not see the tables you showed above?

             

            table calculations work on the table that underlays each worksheet individually - to use them on a common sheet the single sheet needs to include all the data and teh table calcs need to be created on that sheet

             

            I.e.  you can not transfer table calc results from one sheet to another

             

            sorry

            Jim

            If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.