Showing last obs when using hierarchies

[JesperNyholm]

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

[PeterWijers · Accepted solution]

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]

Hi Peter

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