Exploring, modeling, 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
Attachment

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

Re: Showing last obs when using hierarchies

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: 172

Re: Showing last obs when using hierarchies

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

Hi Peter

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

Post a Question
Discussion Stats
  • 2 replies
  • 238 views
  • 0 likes
  • 2 in conversation