Re: $$Excel-Macros$$ Pivot Table Percent of Column...

2011-08-26 Thread XLS S
try formula please find attachment... On Thu, Aug 25, 2011 at 8:04 PM, Robert Jacobs wrote: > Thanks in advance experts!!! This is very complicated to explain, but > I'll give it a go: > > I have data (Invoice#, Invoice Year, Cat1 Sales, Cat2 Sales, Cat3 > Sales), and need to find the pe

Re: $$Excel-Macros$$ Pivot Table Percent of Column...

2011-08-26 Thread Robert Jacobs
Thanks to everybody for their suggestions. Fred - I couldn't layout my data the way you suggested, just due to the sheer number of rows it would have created. The data I provided was a joke compared to what is actually listed, and the number of categories is much, much more than the 3 I gave in m

Re: $$Excel-Macros$$ Pivot Table Percent of Column...

2011-08-26 Thread §»VIPER«§
Hi please find the attachment it may help -- *Great day,* *viper * On Fri, Aug 26, 2011 at 2:13 PM, Daniel wrote: > Have a look at the page : > > http://support.microsoft.com/kb/106359/en-us > > Daniel > > -Message d'origine- > De : excel-macros@googlegroups.com [mailto:excel-mac

RE: $$Excel-Macros$$ Pivot Table Percent of Column...

2011-08-26 Thread Daniel
Have a look at the page : http://support.microsoft.com/kb/106359/en-us Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Robert Jacobs Envoyé : jeudi 25 août 2011 16:35 À : MS EXCEL AND VBA MACROS Objet : $$Excel-Macros$$ P