08-01-2017 08:18 AM
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.
08-01-2017 01:09 PM
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
08-01-2017 03:02 PM
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.