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

Aggregate on Specific group by

Reply
Contributor
Posts: 35

Aggregate on Specific group by

Hi All,

 

Could any one suggest how to get aggregate percenatge dynamically (sum of percentage for each year should be 100%).

For reference i have attached snapshot.

Temperorary i have created aggregation however i want that should be in dynamic so if we apply any filter or drill down further or any control it should have cumulative 100% for each year .

 

Please suggest.

 

Attachment
Attachment
Occasional Contributor
Posts: 5

Re: Aggregate on Specific group by

Hi,

This link can help you.

http://blogs.sas.com/content/sgf/2016/06/21/need-an-aggregation-of-an-aggregation-use-visual-data-bu...

If you schedule your query, it is automatized.

I hope it is useful for you.
Post a Question
Discussion Stats
  • 1 reply
  • 123 views
  • 0 likes
  • 2 in conversation