Pulling Data from a Query RRS feed

  • Question

  • Question?

    Do I need to load the data from a query into the spread sheet to use it or can ref a cell (SumIFS) directly to the query, without haveing to load the data? 

    If so how?

    Wednesday, November 20, 2019 7:51 AM


  • Hi,

    No, you can't use excel formulas to refer directly to the query.

    You have following options:

    1. Load data to sheet.

    Then you may create pivot table and/or use Excel formulas (like SumIFS or GETPIVOTDATA).

    2. Load data to Data Model

    Then you may refer to Data Model with pivot table or cube formulas.

    3. Create pivot table directly from the query.

    Wednesday, November 20, 2019 9:00 AM