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
com]
> > De
> > la part de Robert Jacobs
> > Envoyé : jeudi 25 août 2011 16:35
> > À : MS EXCEL AND VBA MACROS
> > Objet : $$Excel-Macros$$ Pivot Table Percent of Column...
>
> > Thanks in advance experts!!! This is very complicated to explain, but I'll
>
ooglegroups.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$$ Pivot Table Percent of Column...
>
> Thanks in advance experts!!! This is very complicated to
acros$$ Pivot Table Percent of Column...
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 percent of sales for each category, for each year in my
data.
For in
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 percent of sales for each category, for
each year in my data.
For instance, if I have:
Invoice#Year
