Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

YTD & MTD as Category

Reply
Senior User
Posts: 1

YTD & MTD as Category

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

Occasional Contributor
Posts: 13

Re: YTD & MTD as Category

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.

Ask a Question
Discussion stats
  • 1 reply
  • 202 views
  • 0 likes
  • 2 in conversation