Hi all, I'm fairly sure that what I want isn't inherently possible, but I'm trying to determine a work around.
I have row level transactional data that is updated multiple times per day. There is a certain set of information our administrators have specifically asked for, that are each aggregations at different levels.
The cross tab ideally would have the programs as headers, and thebn each row would be an aggregation level, such as:
Program 1 |Program 2| Program 3
Total Outstanding Bal |
Num Orders |
Avg Order Bal |
Num Customers |
Avg Bal per Customer |
I can't for the life of me figure out how to use the row level data to achieve that. I've thought about producing a table in the backend that simply has 3 columns like this:
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.