"ProJester" wrote:

> Hi, Roni
> It is very strange how you ended with such % calculations they are not
> correlate to the numbers (spatially in gold, platinum and so on it is
> probably means something),
> In any case, you can use calculated field with formula expression in the
> same matrix.
>
> Regards, ProJester,
> MSN Programmer.
>
> "aaron" wrote:
>
> > Hello Chris,
> >
> > I have a data set with the following fileds:
> > plan
> > month
> > leads
> > orders
> >
> > I have made the following matrix table: month for column, plan for row, and
> > leads and orders for the details, and subtotals.
> > ----plan----------Jan------------Feb---------Total
> > --------------leads orders-leads orders-leads orders
> > GOLD ---------9------8------17-----12----26-----20
> > GOLDP --------9------7------38-----21----47-----28
> > PLATINUM ----6------3------8-------6-----14------9
> > PLATINUMP --550--343----954----572---1504--915
> > GrandTotal ---574--361---1017----611---1591--972
> >
> > i want to add another column that calculates the percentage of
> > total orders / total leads, so it should look like this
> >
> > ----plan----------Jan-----------Feb----------Total---------% ordered
> > ------------- leads orders leads orders leads orders
> > GOLD ---------9------8------17-----12----26-----20-------76.92 %
> > GOLDP --------9------7------38-----21----47-----28-------59.57 %
> > PLATINUM ----6------3------8-------6-----14------9-------64.29 %
> > PLATINUMP --550--343----954----572---1504--915------60.84 %
> > GrandTotal ---574--361---1017----611---1591--972
> >
> > I have spent a many hours working on it. i ended up adding another table
> > just for the % ordered column, but it's impossible to align it with the
> > matrix table.
> >
> > Is there anyway i can integrate it into the matrix table?
> >
> > thanks
> >