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

Showing last obs when using hierarchies

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 9
Accepted Solution

Showing last obs when using hierarchies

Hi How can one make SAS VA show last occurrence, instead of summing all months when collapsing a hierarchy? Best regard Jesper
Udklip.JPG

Accepted Solutions
Solution
‎02-23-2016 12:51 PM
Regular Contributor
Posts: 183

Re: Showing last obs when using hierarchies

Posted in reply to JesperNyholm

Hi Jesper,

Don't use a hierarchy then.

Create a seperate year and kwarter selection and report on month.

Or use the year / kwarter filter and see the fitered results in your crosstable with hierarchy.

 

Greetings and good luck.   Peter

View solution in original post


All Replies
Solution
‎02-23-2016 12:51 PM
Regular Contributor
Posts: 183

Re: Showing last obs when using hierarchies

Posted in reply to JesperNyholm

Hi Jesper,

Don't use a hierarchy then.

Create a seperate year and kwarter selection and report on month.

Or use the year / kwarter filter and see the fitered results in your crosstable with hierarchy.

 

Greetings and good luck.   Peter

Occasional Contributor
Posts: 9

Re: Showing last obs when using hierarchies

Posted in reply to PeterWijers

Hi Peter

Thanks for the help. Quite of a step backwards compared to OLAP , but it works Smiley Happy.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 304 views
  • 0 likes
  • 2 in conversation