Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Try like this:
expression:
if(ColumnNo()=1,1,if(ColumnNo()=2,2,3))
Br,
KC
Try like this:
expression:
if(ColumnNo()=1,1,if(ColumnNo()=2,2,3))
Br,
KC
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..
Thank you. Your example has helped me a lot.