I would ask for any assistance on the following.
In SAS VA in Report Designer, I am tring to create "Button Bars" options so the users can select which measure to view.
Say for example, for some Product Lines I want to see three measures of two different months:
Below how the data looks like:
I have gone through and created the New Custom Category, the New Parameter and the New Calculated Item. The "Buttons" I have created are as follows:
But when I create the Calculated Item I can only return either Jan or Feb data for all the measures and as a result I can only vusualise only one month.
Is there any way to visulaise both months? In other words, can I create the "Buttons" in a different way so that when I click on them both months appear?
Hope it makes sense.
What happens if you restructure your data to a long format, with the following type layout and thn add the Measure as a Button Bar.
Not sure if this is possible given your other needs.
Product Month Measure Value
Product1 Jan Quantity 1
Product1 Jan Average 2
Thank you for your reply.
I guess I will have to restructure lots of my data. I just started to use SAS VA.
However, what I did was to create thre Calculated item twice: one for Jan and one for Feb. And when I create any visualisation I drag and drop both.
SAS is headed back to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team.
Interested in speaking? Content from our attendees is one of the reasons that makes SAS Innovate such a special event!
Submit your idea!
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.