Report to fetch from 2 tables

[Anonymous]

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

[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.