Dynamic percentage calculations

[sasuser381]

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.

[MikeJenista · Accepted solution]

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.

[sasuser381]

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

[FredrikE]

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