2 Replies Latest reply on Mar 30, 2016 11:15 AM by Jeffrey Jacob

    Max Value Across Multiple Columns of a Dimension for Measure Values (Multiple Aggregated Measures)?

    Jeffrey Jacob

      My cross-tab has columns using a Customer dimension with > 100 Customer Names.  I have several aggregated measures as rows (e.g., sum of sales, sum of profit, count of items purchased).


      I would like to generate a 1-column view with only the max value for each measure, regardless of the customer to which the value is associated.


      For example, my 'before' view is as follows:

                               Customer 1               Customer 2               Customer 3

      Sales                $100                          $300                         $500

      Profit                $5                              $50                            $0

      Purchased       10                              2                                5


      My desired 'after' view is as follows:

      Sales               $500

      Profit               $50

      Purchased      10


      Is this possible?