topic Re: SAS Add In for Excel 2007 in Microsoft Integration with SAS https://communities.sas.com/t5/Microsoft-Integration-with-SAS/SAS-Add-In-for-Excel-2007/m-p/12220#M363 <HTML><HEAD></HEAD><BODY><P>I was also investigating the SaS OLAP visual totals issue. Has this been resolved in&nbsp; <BR />the latest version of the add-in version 5.1?</P></BODY></HTML> Tue, 08 May 2012 12:46:59 GMT brianj 2012-05-08T12:46:59Z SAS Add In for Excel 2007 https://communities.sas.com/t5/Microsoft-Integration-with-SAS/SAS-Add-In-for-Excel-2007/m-p/12218#M361 Hi, <BR /> I am using SAS Addin in Excel 2007 to access SAS OLAP cube.<BR /> Is it possible to have the Grand Total in Excel Pivot table to exlude the filtered items ? When I tried to unclick the option it gave me the message saying "This data provider does not support totals that exclude hidden items"<BR /> Thanks. Thu, 05 Nov 2009 02:38:47 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/SAS-Add-In-for-Excel-2007/m-p/12218#M361 dh888 2009-11-05T02:38:47Z Re: SAS Add In for Excel 2007 https://communities.sas.com/t5/Microsoft-Integration-with-SAS/SAS-Add-In-for-Excel-2007/m-p/12219#M362 Unfortunately, the SAS OLAP provider does not currently support visual totals. We are researching adding this functionality in a future release. Thu, 05 Nov 2009 15:46:52 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/SAS-Add-In-for-Excel-2007/m-p/12219#M362 CaseySmith 2009-11-05T15:46:52Z Re: SAS Add In for Excel 2007 https://communities.sas.com/t5/Microsoft-Integration-with-SAS/SAS-Add-In-for-Excel-2007/m-p/12220#M363 <HTML><HEAD></HEAD><BODY><P>I was also investigating the SaS OLAP visual totals issue. Has this been resolved in&nbsp; <BR />the latest version of the add-in version 5.1?</P></BODY></HTML> Tue, 08 May 2012 12:46:59 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/SAS-Add-In-for-Excel-2007/m-p/12220#M363 brianj 2012-05-08T12:46:59Z