BookmarkSubscribeRSS Feed
barada1
Calcite | Level 5

Hi Folks,

 

How to Calculated YTD & MTD as Categorical Variable?

 

 we wanted to use YTD & MTD as category rather than Aggregated measures so that we can control the Premium & policies through the control panel with respect to YTD & MTD. Though it can be achieved through Cumulative & Parallel Period ,it can be only used as Aggregated measures not Category.

 

Can you suggest any solution for this particular problem ?

 

Regards,

Prasanna

1 REPLY 1
alineagostini
Obsidian | Level 7

Hi,

 

This article may not be specific to your case but it can give some insights on how YTD and MTD variables could be created as categories and then applied as filters / parameters. In this case, the data prep is the key. Maybe you could use part of it to solve your problem.

 

https://communities.sas.com/t5/SAS-Communities-Library/Making-VA-reports-more-dynamic-category-measu...

 

Hope it helps.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

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.

Discussion stats
  • 1 reply
  • 1201 views
  • 0 likes
  • 2 in conversation