I currently have a report that contains a crosstab. Each row is a different property and each column is a different time. Several of the entries in the table are blank i.e. not all properties are recorded at all the times.
I would like to be able to turn this report into a list of the most recent values for each property along with the time it was recorded. I would be very grateful if someone could provide an example of a formula that would approximate this. Please let me know if I have not provided enough information.
Many thanks
JonI think you must ckick the time field in crosstab expert then select ascending.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment