Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.