how in excel do we create aggregates of the sort an olap tool crea

[christopher ward]

hi all and thanks if you respond

a quick question if you have a range full of values how do you create a
total function that breaks the amounts by a break point similar to the pivot
table function - for those who know Oracles OLAP DML or Express Server or
Personel Express my example is

limit product code to all
limit brand to all
report width 30 total(sales brand )

where product code has been related to brand

so can we force excel to do this easily


--
C Ward

[Tushar Mehta]

Since you know a PivotTable does what you want why not use one?

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach


"christopher ward" wrote:

> hi all and thanks if you respond
>
> a quick question if you have a range full of values how do you create a
> total function that breaks the amounts by a break point similar to the pivot
> table function - for those who know Oracles OLAP DML or Express Server or
> Personel Express my example is
>
> limit product code to all
> limit brand to all
> report width 30 total(sales brand )
>
> where product code has been related to brand
>
> so can we force excel to do this easily
>
>
> --
> C Ward

[christopher ward]

lots of reasons - but for one im working in a multi page form with a user
clicking on
values - i dont expect my users to understand pivot tables nor do i
understand them fully myself

can a pivot table be added to a user form ? - i suspect not as the toolbox
is limited so therefore i thought maybe i could create a function that does
the calculation that i need and i could put the results in a display object

thank you for your advice and interest
--
C Ward


"Tushar Mehta" wrote:

> Since you know a PivotTable does what you want why not use one?
>
> --
> Regards,
>
> Tushar Mehta
> www.tushar-mehta.com
> Custom business solutions leveraging a multi-disciplinary approach
>
>
> "christopher ward" wrote:
>
> > hi all and thanks if you respond
> >
> > a quick question if you have a range full of values how do you create a
> > total function that breaks the amounts by a break point similar to the pivot
> > table function - for those who know Oracles OLAP DML or Express Server or
> > Personel Express my example is
> >
> > limit product code to all
> > limit brand to all
> > report width 30 total(sales brand )
> >
> > where product code has been related to brand
> >
> > so can we force excel to do this easily
> >
> >
> > --
> > C Ward

[christopher ward]

i should also add my data is timestamped so its not easy to sort it into
groups and then use excel to calcualte using sum


--
C Ward


"christopher ward" wrote:

>
>
> lots of reasons - but for one im working in a multi page form with a user
> clicking on
> values - i dont expect my users to understand pivot tables nor do i
> understand them fully myself
>
> can a pivot table be added to a user form ? - i suspect not as the toolbox
> is limited so therefore i thought maybe i could create a function that does
> the calculation that i need and i could put the results in a display object
>
> thank you for your advice and interest
> --
> C Ward
>
>
> "Tushar Mehta" wrote:
>
> > Since you know a PivotTable does what you want why not use one?
> >
> > --
> > Regards,
> >
> > Tushar Mehta
> > www.tushar-mehta.com
> > Custom business solutions leveraging a multi-disciplinary approach
> >
> >
> > "christopher ward" wrote:
> >
> > > hi all and thanks if you respond
> > >
> > > a quick question if you have a range full of values how do you create a
> > > total function that breaks the amounts by a break point similar to the pivot
> > > table function - for those who know Oracles OLAP DML or Express Server or
> > > Personel Express my example is
> > >
> > > limit product code to all
> > > limit brand to all
> > > report width 30 total(sales brand )
> > >
> > > where product code has been related to brand
> > >
> > > so can we force excel to do this easily
> > >
> > >
> > > --
> > > C Ward