Results 1 to 6 of 6

Thread: Inserting a different total to a column

  1. #1
    Neophyte Neville's Avatar
    Join Date
    Mar 2014
    Location
    South Africa
    Posts
    3
    Articles
    0

    Inserting a different total to a column



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi there. I have a rather interesting situation. I need to put a different total to a column i.e I have a pt where there is a 'Units sold' column but rather than having 'total units sold' at the end of the column, I would like to insert a 'total money value'. Is this possible? Would I need to change the mdx?

    I source my data from cubes on analysis services.
    Many thanks

  2. #2
    Are you talking about the heading? If so, just rename it.

  3. #3
    Neophyte Neville's Avatar
    Join Date
    Mar 2014
    Location
    South Africa
    Posts
    3
    Articles
    0
    Hi Bob...no I'm looking to replace the total units number with a monetary value. So the column displays the units sold but at the end where you're supposed to have total units sold you'll have the monetary value

  4. #4
    You mean you want to show just the total as a monetary value? I can't see that being possible, that is a fundamental part of the pivot.

    Why not just add a value column to your pivot and that will total?

  5. #5
    Neophyte Neville's Avatar
    Join Date
    Mar 2014
    Location
    South Africa
    Posts
    3
    Articles
    0
    Hi Bob...now you understand my frustration! The CEO wants it that way and I've told her this is not how pivots work...I've racked my brains over this one but I reckon I'll have to 'sell' another way of presenting the data.

    Many thanks - this is a great site btw I've learnt a lot here

  6. #6
    Would it be okay to have two pivots, one showing all of the rows with the units number, and a separate one showing just a grand total of value?

Posting Permissions

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