Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Here's the Load Script
RealData:
LOAD Line, Entity, Value INLINE [
Line, Entity, Year, Value
1, Nate, 2010, 1.1
1, Navya, 2010, 1.11
];
LineLookup:
LOAD Line, Category INLINE [
Line, Category
1, First Category
2, First Category
3, Second Category
];
And here's the result.
I'm expecting the table not to ignore the relationship between "Category" and "Line" where I've marked in red.
(Ideally Category remains as the first column [does that mean it must be a Dimension?] , so that the "grouping effect" of the "Pivot Table " > "Always Fully Expanded" will continue to group by Category)
Maybe like attached.
You probably know that selecting in field Entity does filter the records, so in your selected set, there is no dimension 2. You would need to use set analysis to overcome this (check my added expression, hidden).
Maybe like attached.
You probably know that selecting in field Entity does filter the records, so in your selected set, there is no dimension 2. You would need to use set analysis to overcome this (check my added expression, hidden).