1 Reply Latest reply: Feb 26, 2018 11:29 AM by Juraj Misina RSS

    Report to fetch from 2 tables

    Prakash S

      I got stuck in below issue:

       

      I am having a Category field and associated data in table.In this category i have multiple type of categories.

       

      I am having another table Category where Categories are grouped in to 3 major group.

       

      Now i need a data view which shows all details(count) based on the category groups.

       

      I am struggling to link two tables and get this report done.

       

      Can anyone help.

       

      Regards

       

      S, Prakash

        • Re: Report to fetch from 2 tables
          Juraj Misina

          Hi,

           

          to associate the two tables the "Category" field must be labeled exactly the same in both of them:

          FactTable:
          LOAD
          ID,
          Date,
          Category,
          Value
          FROM Source;
          
          CategoryGroups:
          LOAD
          Category,
          CategoryGroup
          FROM Source2;
          

           

          Then you can use CategoryGroup as a dimension and Sum(Value) as an expression.