VisualTotals

#1

You can create a scenario dimension that contains the
formula of what you want sum. You can also give the
scenario rows your custom display values. I recommend
the MAS tutorial section 3 with Advanced Calculations.

Quote:

-----Original Message-----
I need a functionality like Visual Totals but I want to
put a custom label than visuatotal do.
Because I want to aggregate two members and put them with
some description.
Is like:

A __
\_Son of A1__
\_Grand Son A1.1
\_Grand Son A1.2
\_Son of A2__
\_Grand Son of A2.1
\_Grand Son of A2.2

And I want to display
A member which is :
Son of A3 = Grand Son A1.1 + Grand Son of A2.2 but I
want to show to by this way
\_Son of A3__
\_Grand Son of A1.1
\_Grand Son of A2.2

Do you understand??
Thanks

.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

VisualTotals

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

VisualTotals - 05-06-2004 , 06:01 PM