Hi Ayushupadhyay,   as far as I know there is no "click and done" way to transpose data in SAS VA. You can write an own code (go to the code section when being in the databuilder queries and unlock the code) and then you can use all Options being offered by SAS BASE. This includes PROC TRANSPOSE (http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a000063661.htm).   However maybe you do not need to summarize the data in the data prep already but can perform this by the Report? Also you might concider working with calculated items in the Report which you can summarize afterwards at run time of the Report. It depends on your data set whether this is an Option for you.   Best, Tobias ... View more

Hi Shanhjad,   I've been using the Button bars, too. See these two blog entries how to use button bars to influence your measures:   http://blogs.sas.com/content/sgf/2016/04/27/use-parameters-to-pick-your-metric-in-visual-analytics-reports/ http://blogs.sas.com/content/sgf/2015/01/29/using-parameters-in-sas-visual-analytics/   You can either use one calculated date with a case (multiple if...else...) or define multiple calculated items and choose by the parameter the item to show.   Best, Tobias ... View more

Hi,   as far as I know the Slider only takes numeric or date/datetime formated variables.   I would try two solutions:   1) Try using the SAS quarter format "1st Quarter 2016" instead of your formatted/calculated variable. If this works I would say: Form follows function.   2) Use a slider with a parameter 1 to 4 and (if you need it) a field or a slider for choosing the year (with a second parameter). Now you can define a calculated measure using the input data of the parameters.   Tobias ... View more