BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
Rightside13
Fluorite | Level 6

I have a cross-tab which contains a number of aggregated measures, below is the calculation for the 'Yield' measure:

Rightside13_0-1655976571087.png

 

I've used the 'Reporting Year' as a column so that we can see the current and previous year values side by side:

 

Rightside13_1-1655976606795.png

 

 

What I now need to do is add another measure which shows the difference between the current and previous year values, I've tried using the Parallel Period Operator but get a 'Nested aggregated expressions are not supported'. I've also found the same problem if I try to create separate Aggregated Measures for each year.

 

Any idea how I can show the difference?

1 ACCEPTED SOLUTION

Accepted Solutions
MarkusWeick
Barite | Level 11

Hi @Rightside13,

just an idea, as I am working on an older VA Version (7.5) so that I can't try the idea myself:

In the article SAS Visual Analytics Advanced Calculations (part 3... - SAS Support Communities

there is a section "Creating an aggregated data source".

In this section is stated "Calculated items and aggregated measures become regular measures in the output table and can be used in new aggregated items and aggregated measures expressions." 

Maybe you can use this to reach your goal.

 

Best

Markus

Please keep the community friendly.
Like posts you agree with or like. Mark helpful answers as “accepted solutions”. Generally have a look at https://communities.sas.com/t5/Getting-Started/tkb-p/community_articles

View solution in original post

3 REPLIES 3
MarkusWeick
Barite | Level 11

Hi @Rightside13,

just an idea, as I am working on an older VA Version (7.5) so that I can't try the idea myself:

In the article SAS Visual Analytics Advanced Calculations (part 3... - SAS Support Communities

there is a section "Creating an aggregated data source".

In this section is stated "Calculated items and aggregated measures become regular measures in the output table and can be used in new aggregated items and aggregated measures expressions." 

Maybe you can use this to reach your goal.

 

Best

Markus

Please keep the community friendly.
Like posts you agree with or like. Mark helpful answers as “accepted solutions”. Generally have a look at https://communities.sas.com/t5/Getting-Started/tkb-p/community_articles
Rightside13
Fluorite | Level 6

Hi,

 

Tried that and it worked, I saw the link you posted yesterday and for some reason dismissed it as a solution.

 

Thanks,

 

RS13

MarkusWeick
Barite | Level 11

I'm glad, it worked.

Best

Markus

Please keep the community friendly.
Like posts you agree with or like. Mark helpful answers as “accepted solutions”. Generally have a look at https://communities.sas.com/t5/Getting-Started/tkb-p/community_articles

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 1162 views
  • 2 likes
  • 2 in conversation