Hi Community,   A 2nd post, for a different problem that I have in SAS VA.  See the attached Excel for the problem description.    To briefly repeat it here:  - I have a report, in which many charts are filtered on 1 parameter (named NR). This is no problem  - Now I want to make a new tab, and filter its charts on the entity that is associated with this number. In my data, 1 entity has multiple NRs and 1 NR always has 1 entity (so based on the NR parameter, I'd like to lookup the entity and filter the charts on this) - I prefer to avoid a 2nd parameter "entity", since it can be derived from NR   I cannot get this (filtering on a calculated field based on my parameter) working in SAS VA... Is this somehow possible?   I have attached an Excelfile with a sample dataset and scenario's to explain the problem better. I discussed it with some colleagues too, but so far no luck (yet). I hope you can shine some bright light on it, or advise me on the solution that fits my requirement best.   Thanks! Roberto ... View more

Hi Community, I'm relatively new into SAS / SAS VA, and I'm running into an issue for which I'd like to make use of your expertise... My question is: "How can I sort my stacked bar-chart by value in SAS VA"?   More details - When I create a bar chart with only categories and 1 measure, by default, the bars are sorted by the value (for e.g. sum of value)  - When I add a 3rd item to this chart (so it will be a stacked bar-chart, I only seem to be able to sort by the category in my chart and not anymore by value   Is this possible at all in SAS VA? And if so, how can it be achieved? It might be that we don't have the newest version (I'm not 100% sure and will check it tomorrow), but in the version at the client where I now work, I didn't get it working.   Please find an excelfile with "sample data" and a pivot-chart in Excel, which does exactly what I want.  The chart is built up by  - taking sum of value (=x-axis) - broken down by ITEM (=y axis) - broken down by GROUP (=stacked bars)   In the example excel, it is sorted (correctly) by the sum of value by ITEM; in SAS VA I need your advise to have the same.   Many thanks for helping; please let me also know if this is not possible, so I can stop searching.   Roberto      Roberto ... View more