SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have an Analytic Grid that has a column with values (for example) {Cat, Dog, Other}. Each of those items have a number associated with them. For example, cat is 10, dog is 10, and other is 2.

In my grid, I only want the Cat and Dog columns to show. So I use the drop down in Dashboard Designer called Select Members. I Choose Cat and Dog. I also want the total of those values in my grid, so I use the checkbox All.

When the grid is displayed. It shows the All field as well, but it lists the value as 22 not the 20 I was expecting.

Is there a way to hide the unselected member values from the all total calculation? (So that the All field would say 20?)

Another way to put this is the example where you can "not include" hidden data in MS Excel Pivot tables.

share|improve this question

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.