Results 1 to 2 of 2

Thread: Exclude certain rows from the grand total

Threaded View

  1. #1
    Join Date
    Jan 2010
    Posts
    1

    Exclude certain rows from the grand total

    Hi!

    I need to exclude some rows from the totals that SSAS do.

    Letra Factura Valor
    1 1 100
    2 200
    3 300
    Total 600
    2 2 10
    Total 10
    5 5 20
    Total 20
    Grand Total 630

    What I want is to have only the sums of the "Facturas" equal to "Letra", but preverse all the "Facturas".

    Letra Factura Valor
    1 1 100
    2 200
    3 300
    Total 100
    2 2 10
    Total 10
    5 5 20
    Total 20
    Grand Total 130

    How can I do this in MDX, or in SSAS 2005?

    Thanks,
    Sérgio Cardoso
    Attached Images Attached Images

Posting Permissions

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