Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i loaded the following value,but when i list it ,im geting only one 9 insted of 2 9's
LOAD * INLINE [
ID
10
9
9
8
7
6
];
load this and create a table box in front end
LOAD * INLINE [
ID,pro
10,a
9,b
9,c
8,c
7,d
6,e
];
in list box you wil get only distinct values
load this and create a table box in front end
LOAD * INLINE [
ID,pro
10,a
9,b
9,c
8,c
7,d
6,e
];
even in pivot table or stright table im nt geting,i usend rank function as expression
Because one again, you only have one dimension (ID) and unless you add another one which essentially repeats the ID, it will only be shown once. You can add another expression as Count(ID) and you will see that ID 9 will have a count of 2
May be work around
Instead, Generate to call RecNo() as ID
yes anil,
but just wanted to show him with other dimension
i have 2 9's so im geting 2-3 and 2-3 for 8 i got 4 ,so i should get 3 as rank for 8,can i get the expression for tat
Try see if you can understand from this thread