Results 1 to 2 of 2

Thread: Paretto

  1. 04-06-2005, 07:45 AM #1
    pabcig
    pabcig is offline Registered User
    Join Date
    Feb 2005
    Posts
    16

    Exclamation Paretto

    Hi! i have the following problem.. i have a mesaure that indicate the units sold and i have to do a paretto. i have to create another mesaure that acumulate the units to do a paretto.
    Ex:
    Units-Acumulative
    3---------3
    5---------8
    6---------14

    How can i do this with a calculated member?


    thank´s
    Paul
    Last edited by pabcig; 04-06-2005 at 08:48 AM.
    Reply With Quote Reply With Quote
  2. 04-13-2005, 03:25 PM #2
    pabcig
    pabcig is offline Registered User
    Join Date
    Feb 2005
    Posts
    16

    Thumbs up

    Ok, i´ve resolved the problem in that way:
    Sum(Head(Order ( {[Centro de Costo].Siblings}, [Measures].[Importe], BDESC) AS OrderedSiblings, RANK( [Centro de Costo], OrderedSiblings )) , [Measures].[Importe])

    Tks
    Paul
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules