12-18-2017 01:09 PM
I'm exporting excel data into SAS VA 7.4 with some duplicate records such as follows:
Date ID Sale_Amount
12/2/2017 XM001 $10,000
12/2/2017 XM001 $12,000
12/2/2017 XM001 $ 8,000
However, in preview section I see all the 3 records. However, in VA Report designer (crosstab, listtable), it's just showing 1 record. Any suggestions please ?
12-20-2017 02:26 AM
In the list table object there is an option "Show details" that allows you to show all records.
You will find it in the properties tab to the right.
12-20-2017 10:17 AM
The purpose with the cross-tab is to do calculations (sum, avg, max, etc) across the selected dimensions.
If you want detailed information you need to add a dimension that contains the detail level (id, key or similiar).