Hi,   It can be achieved if you create a custom graph .   1)In custom graph first select multiple pie charts based on your requirement. 2)create one shared rule for category 3)apply that shared rule to all graphs which you selected.   If you use that custom graph in report...category will be same for all graphs and you can select different measure for each graph seperately.then you drill on one graph all graphs will drill.     In the above i createted one shared rule - Shared rule 1 and applied it to all piecharts in the place of category     Regards, Vivek R ... View more

Hi, not sure if you are still looking for solution. I have found a solution into creating such chart.   It will be a bit tedious but what you need to do is to take identify all the categories and do a percentage conversion    <category>/<total number>  -> Then use this to convert it to percentage. This will do the trick for now. Hope SAS VA can release the norminal functionality to all the graphs ... View more

Hi, I tried to use parameters in my url and it works fo me. I refered to the blog below: http://blogs.sas.com/content/sgf/2015/09/16/accessing-va-reports-with-parameterized-urls/ But, it would be great if SAS had these features automated. Regards, Abhi ... View more

Firstly, please don't type all in capitals.   Secondly, whilst I don't personally use VA, a quick look at the documentation shows that a calculated field accepts and expression.  And epression is a series of operations (+/-* etc) which end in a value.  It does not say anything about code constructs. http://support.sas.com/documentation/cdl/en/vaug/65747/HTML/default/viewer.htm#p0i4r7imon277qn1fzfigcuzfxfa.htm   I would suggest you need to think about your data differently, or processs it further before moving into analytics (I don't know the functionality of the software, whether you could write datastep code in it). ... View more

Hi, Thank you very much for reply. Tally has options to connect with Microsoft query and get data into Microsoft Excel. Every time if data is refreshed we had to open excel and  refresh the data.Is there any option to automate data refresh from excel while reading into SAS. ... View more