Solved
New Contributor
Posts: 4

# Dynamic percentage calculations

[ Edited ]

Hello everyone,

Variables I have on my chart are:

measures

- total number of customers (1)

-number of customers who have certain product (2)

dimensions

-months

interactive filters are:

-products (you can choose only one)

-activity (you can check 1 of them or both if you want to see numbers for all customers )

-wage category (also 1,2 or 3)

what I want is to calculate percentage of numbers of customers with product for each month, but for each combination of filters.

For example: if I check customers from 2 activity categories and 1 wage category, for 1 activitiy and 1 salary category etc...So for each combination of filters I need different calculations.

How can I do that?

Version of SAS VA I use is

SAS® Visual Analytics Hub 7.2

Accepted Solutions
Solution
‎06-27-2018 04:35 AM
SAS Employee
Posts: 31

## Re: Dynamic percentage calculations

At first glance, it sounds like an aggregated calculation will work.  But what exactly is your 'chart'?  A crosstab or list table?  A bar chart?  The possibilities will be different based on what kind of chart you are using because the number of measures you can assign will be different.

All Replies
Solution
‎06-27-2018 04:35 AM
SAS Employee
Posts: 31

## Re: Dynamic percentage calculations

At first glance, it sounds like an aggregated calculation will work.  But what exactly is your 'chart'?  A crosstab or list table?  A bar chart?  The possibilities will be different based on what kind of chart you are using because the number of measures you can assign will be different.

New Contributor
Posts: 4

## Re: Dynamic percentage calculations

Thank you very much, aggregated calculations worked for me, because measures are calculated after filtering.

PROC Star
Posts: 398

## Re: Dynamic percentage calculations

Not really sure what you want, but by using cross tables and/or a set of objects you should be able to get what you want....

//Fredrik

☑ This topic is solved.