How do I exclude a detail measure value and only view Grand Total

B

boston_sql92

How do I exclude a detail measure value and only view Grand Total without
Hiding in Excel





CustomerNumber 1 2
3

Sale SaleTotal Sale SaleTotal
Sale Sale Total Total Sale Total SaleTotal

SalesPerson Mark 50 350 100 350
200 350 350 350





In the above Excel Pivot Table illustration I have the CustomerNumber
dimension running on the x axis and SalesPerson dimension running on the y
axis. I have one measure "Sale" and one calulated measure "Sale Total", which
is the sum of all Sales for a SalesPerson.



How do I display this data in Excel but not repeat the "Sale Total" for each
customer number? I simply want to display it once in the far right as the
"Total SaleTotal".



I do not want to hide the "Sale Total" detail values (a.k.a) values since
that would cause problems for users who open the pivot in Excel and try to
perform further analysis not knowing there are hidden fields and running into
problems because of this ignorance.



Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Grand Total for Rows not Working in a Pivot Table 1
How to ignore a column of numbers in Grand Total for rows 1
Pivot Table design problems (% of grand total etc) 1
How do I perform extended calculations in a Pivot Table in Excel 2 4
How do I set a cell that can increase but never decrease? 2
Only grand total in Pivot Table 1
Calculate a Grand Total 4
Pivot Chart - adding Grand Total to chart 0

Top