topic Showing last obs when using hierarchies in SAS Visual Analytics

Showing last obs when using hierarchies

JesperNyholm — Thu, 18 Feb 2016 14:04:36 GMT

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

PeterWijers — Fri, 19 Feb 2016 06:05:39 GMT

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

JesperNyholm — Fri, 19 Feb 2016 08:02:08 GMT

Hi Peter

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