This is no technical issue, welcome to aggregated measures. I would need more information about the table behind.  What is the aggregation context, sum? several rows of data are condensed in 1 line of the cross table? ... View more

Hi there,   You can publish an interactive report on your website, you'll need to follow a few steps to do that:     1- To allow external access to report without needing user credentials you have to enable guest access. Which you can do following this steps: In SAS Management Console, navigate to Application Management > Configuration Manager „ > SAS Application Infrastructure. Expand Visual Analytics and set the AllowGuest property to true on the Advanced tab in the Properties for these components: Visual Analytics Services > Visual Analytics Transport Service Visual Analytics Viewer Visual Analytics Hub Restart the web application server.   2- You may have to give permission for external websites to access SAS Server (put your website or domain in the "whitelist"). You can find all the information on this link (http://go.documentation.sas.com/?docsetId=bimtag&docsetTarget=p1xtsni38p58t3n1ljd2fy4c3joz.htm&docse...   3- Get the URL to the report which you can use this model that already works for me:  <http://YourSasServer/SASVisualAnalyticsViewer/VisualAnalyticsViewer_guest.jsp?reportPath=/Shared+Data/&reportName=RerportName> You will replace the bold for the information on your report, if you have any "space" in the report name or the report path you can replace it for "+" You can find a few more details on report path and parameters to URL on this link (https://amadeus.co.uk/sas-tips/passing-parameters-into-a-visual-analytics-report/)     I Hope it helps! Best Regards Glaubert ... View more

Thank you so much,this was really Helpful!!!! ... View more

Hi Guys,   Is there anyone to give me a solution on the same query?   I'm facing problem still.   Regards, Sunny Kumar Gupta ... View more

Hi, Unfortunately, we are unable to share this data set due to some sensitive information in it. If we can help with any other data that you have, don't hesitate to reach out, though. Happy to help you build some correlations and forecasts. ... View more

Hi.   Can you be more specific? If you are trying to group categorties together that is not possible in VA.However if there is a category which has different data vaules you can create a custom category to edit and manipulate those data values however you want. ... View more

Thanks So much Varsha.This led me to another thing which I am going to post. ... View more

Hi.   There is a simple way to achieve it by making use of the same gauge for individual models as well as all the car models whem no selection is made.All you have to do is create a list of all the car models on one side and make it interact with the gauge on the other.This way you can have indiviual figures for each car as well the total figure when all of the 15 models are selected.   Cheers! ... View more

Is this a one time shot, or are you preparing a more permanent solution? If so, your proposed solution might be optimal. To search for a specific phon no needs scanning through a variable length variable, which is not query friendly. Consider a to normalize the table structure instead, either by having separate phone and a email tables, or a common with contact type and the address (phone no or email). ... View more