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
Thank you in advance.
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.
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.
Thank you very much, aggregated calculations worked for me, because measures are calculated after filtering. 🙂
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.