Hi, I have 3 ("customers") that have purchase data in different ranges of dates. I would like to have a list box that shows me the range of dates associated with the customer selected.
Similarly, I would like to check for min/max values (range) of product volume to ensure no negative values and to have a box that reports that info for all or each of the respective date ranges. In a sense, this would serve as error reporting for the input side.
Are you sure you want a listbox? I would normally do this with a Straight Table Chart with a dimension of Customer and two expressions, "max(date)" and "min(date)".
Or if you want to show the complete range for all selected customers, a textbox with the expression =min(date) & " " & max(date).
Are you sure you want a listbox? I would normally do this with a Straight Table Chart with a dimension of Customer and two expressions, "max(date)" and "min(date)".
Or if you want to show the complete range for all selected customers, a textbox with the expression =min(date) & " " & max(date).
