Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Friends,
I have 2 columns Name and Mark.
Name | Mark |
AAA | 56 |
bbb | 26 |
ccc | 45 |
I have 2 list box and 1 table box.
I need to have ALL in Name column , when i select ALL it should display all the names and mark in Table box.
How can i achieve this in List box?
Please help me out.
May be like attched sample:
ALL is aggregate function you ca use for Mark field like
SUM(ALL Mark)
Note:- SUM(ALL Mark) will give you all sum 127.
Another approach to select all
UPDATE : Right Click on list box and select all...
May be like attched sample:
How can i bring "ALL " to first row.
Sort tab->Expression: =Match(Name2, 'ALL', 'AAA', 'bbb', 'ccc')
Update: If you want the same even when selection is there, try: =Match(Only({1}Name2), 'ALL', 'AAA', 'bbb', 'ccc')
If i have n number of data in Name column , how can i use this?
Its working when i select,
Tab -> Sort -> Expression - Descending and
=Match (Name2,'ALL')
It will work even if we have n number of values in Name2 Column. Without giving each data in match function.
Thanks for all your help!!!
Load a new table above the main table then you are able to get this see Eg
LOAD RowNo() as Rcid,Name,Mark;
LOAD * Inline
[
Name,Mark
ALL
];
Tab1:
LOAD RowNo() as Rcid,Name,Mark;
Load * Inline [
Name, Mark
AAA, 56
bbb, 26
ccc, 45
];
Hope this helps
If in sort you use expression Rcid then your data arrange according to the rowno sequence see my example above.