Hi,
i'm trying to write a share formula, i need some help to do something like
this :

Country Product Line
---------------------------------------------------
United States Accesory 40 % 400 $
Components 25 % 250 $
Mountain 5 % 50 $
Road 15 % 150 $
Touring 15 % 150 $
Total 100 % 1000 $

Country Product Line Reseller
----------------------------------------------------------------
United States Accesory Reseller1 50 % 200 $
Reseller2 30 %
120 $
Reseller3 20 %
80 $
Total 40 %
400 $
Components 25 % 250 $
Mountain 5 %
50 $
Road 15 %
150 $
Touring 15 %
150 $
Total 100 %
1000 $

I must calculate the relative share with the previous selected dimension, is
it possible? i can't found the way. The dimensions are not fixed, would be
others. The only thing i know is i will have present the market on my rows
selections, in this case the country.
Thanks, Mariana.

I write this, this works fine but its too low, someone know how to rewrite
it better ?

Medida.Medida.&[1]/IIF(Producto.Marca.CurrentMember is producto.Marca.[Todos
los Productos],IIF(Exportador.Empresa.CurrentMember is
Exportador.Empresa.[Todos los
Exportadores],IIF(Producto.Variedad.CurrentMember is
Producto.Variedad.[Todos los
Productos],Medida.Medida.&[1],(Producto.Variedad.[Todos los
Productos],Medida.Medida.&[1])),(Exportador.Empresa.[Todos los
Exportadores],Medida.Medida.&[1])),(producto.Marca.[Todos los
Productos],Medida.Medida.&[1]))*100

Thanks, Mariana.

"Mariana" <melelen (AT) hotmail (DOT) com> wrote