Different dimension fields have different expressions

[Anonymous]

Dear All：

   Hi,My goal is shown below：

Resources：

LOAD * INLINE [

   PP,  Set, Value

   MM, AA, a1

   MM, AA, a2

   YY, AA, a3

   YY, BB, b1

   HH, BB, b2

   HH, BB, b3

   XX, CC, c1

   XX, CC, c2

   XX, CC, c3

];

Try the results:

Can you help me?

[jyothish8807 · Accepted solution]

Try like this:

expression:

if(ColumnNo()=1,1,if(ColumnNo()=2,2,3))

Br,

KC

[Anil_Babu_Samineni]

Not sure, What you are looking, If you create 3 dimensions and without measure you will reserve it,

1) Make sure, to change from column to row of second and third dimensions

2) Suppress null value in presentation tab..

[Anonymous]

Thank you. Your example has helped me a lot.