SAS Visual Analytics Tips & Trick Series: Let’s get Aggregated with AggregateTable – Part 2

[#1]

.

How to become a professional and more efficient using SAS Visual Analytics

Part 2: Let’s investigate some % of sub-total use cases and different approaches using AggregateTable

In Part 2, we are going to continue our journey exploring this fantastic AggregateTable function by looking at different percentage of sub-total use cases. We are going to look at different scenarios, where we use the AggregateTable function with different options to be able to meet our end user requirements.

.

1. Short introduction to all use cases in this video (0:44)

2. Use case 1: Classic % of sub-total use case: How to calculate % of total on a sub-group, by individual Week (1:23)

3. Use case 2: How to calculate % of total on multiple sub-groups, by individual Week and Product Brand (5:00)

4. Use case 3: How to calculate % of total on one sub-group, but independent on displayed weeks (6:35)

Previous videos in this mini-series:

Part 1 - AggregateTable function introduction and two simple use cases, which I think is a good way to get you started using this fantastic function: Click here to go to Part 1!

To get back to the main page of the SAS Visual Analytics Tips & Trick Series, just follow this link!

Please note: All data used in my videos are either fictive demo data or open public data

SAS Visual Analytics version used in this video: 2026.06

(Please Note: Function AggregateTable is available on Viya 3.5 as well)