Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Header 2 | Header 3 | Header 4 | Header 5 | ||||||
---|---|---|---|---|---|---|---|---|---|
Country | Expression1 | Expression2 | Expression3 | Expression5 | Expression6 | Expression6 | Expression7 | Expression8 | Expression9 |
India | |||||||||
US | |||||||||
Uk |
Hi I have created straight table with 8-10 expressions and trying to classify under different header title(same as above).
Can some one assist me to achive above visualization
Many Thanks in Advance
Deepak
First< i would load the dimensional structure in the load script To mimic your example, you need something like:
Dimension:
LOAD Dual(Detail, RowNo()) as Detail,
Header
Inline
[
Detail, Header
Expression1, Header 2
Expression2, Header 2
Expression3, Header 3
...
];
The dual makes Detail numeric which simplifies the expressions.
Now create a pivot table dimensions Detail, Header, Country .
Add an expression of the form:
Pick(Detail,
// expression 1
... ,
// expression 2
... ,
// expression 3
... ,
)
Replace the ellipses with the actual expressions you need in each column.
Now pivot the table by dragging the Detail and Header to the top of the table.
You may elaborate more with Sample Data that offers you lot. this is my personal advice
W1) We can create Valuelist Calc Dimension and then use those Expression for specific metrics like
ValuesList('Header 3','Header 4','Header 5')
Expression would be
If(ValuesList('Header 3','Header 4','Header 5') = 'Header 3', Expression1, Expression2)
This will come like Header 3 as shown above table