Display Filtered total from OLAP in Excel 2007

Question

Display Filtered total from OLAP in Excel 2007

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

gtschech Ten Centuries Points: 1351 More actions · Answer 1

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 · Answer 2

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