How can we create multiple aggregate measures from the same table based on different filter criteria such as follows in the same Report Designer in SAS VA:
select distinct count(id) from abc where type in ('A','C') and month=month(today())-1
select sum(amount) from abc where type in ('A','C') and country='US'
select sum(c_bal) from abc where type in ('C') and region = 'NE'
I'm able to create aggregate measure but not finding filter criteria. When I'm filtering it's applying on the whole job in the designer. I just need to limit filter criteria for one aggregate measure only as I need to create multiple aggregate measure with different filter criteria.
Any insight would be helpful and thanks in advance !
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.