Classify expressions in different category

[dsharmaqv]

	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

[jonathandienst]

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.

[Anil_Babu_Samineni]

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