BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Obsidian | Level 7

## Dynamic percentage calculations

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

Thank you in advance.

1 ACCEPTED SOLUTION

Accepted Solutions
SAS Employee

## 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.

3 REPLIES 3
SAS Employee

## 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.

Obsidian | Level 7

## Re: Dynamic percentage calculations

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

Rhodochrosite | Level 12

## 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

Discussion stats
• 3 replies
• 881 views
• 0 likes
• 3 in conversation