maxstring() help

[mansi_dv]

I am using maxstring function to select values from listbox and displaying corresponding data in pivot table. But when i clear my selections, the table remains populated with the data corresponding to the last value in the listbox.

Can anyone help me out how to remove that condition?

[alexandros17]

post your document

[#3]

hi

MaxString() function--

Returns the last text value of expression over a number of records, as defined by a group by clause. If no text value is found, NULL is returned.

Example:

Load Month, MaxString(Month) as LastSalesMonth from abc.csv group by Year