Display Filtered total from OLAP in Excel 2007

• gtschech

  Ten Centuries

  Points: 1351

  More actions

  November 11, 2010 at 4:54 am

  #1249403

  Jason,

  assuming that you use the Pivot Table functionality to retrieve the data in Excel, you can control whether or not the totals include all values.

  Just right-click the pivot table and select 'Table Options'; there you'll find the option to display only totals of members shown.

  WM_JUSTMY2CENTS

  Guenter

• Jason-1080732

  Mr or Mrs. 500

  Points: 546

  More actions

  November 11, 2010 at 6:18 am

  #1249447

  Guenter,

  thanks for the reply.

  I am using a pivot table to display the result set, but what I am trying to display is a calculated member from the cube based on the mdx that I posted... it is a total of all selected members that should appear against each member of the table. The sum totals that the pivot generates are not related to my problem.

  regards,

  Jason