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 a SQL table (or a BDC list if it's easier) that I would like to have a count of certain values. There is one column I want to see how many of each value are in the table. Everything I've seen for PerformancePoint is totaling (sum) of columns, how can I just report on filtered counts?


share|improve this question
up vote 2 down vote accepted

Click on your Data Source under your Data Connections in Dashboard Designer.

Go to the View tab and click the column you want to have counted. Under the details pane you can change the Aggregation, the default is Sum, click the drop down list and you should have Count there.

share|improve this answer

Does that solution work for external lists as well? If not, here's a solution done with a SQL View:

-- Create a view that will combine all of my rows that were inserted on the same date and
-- provide a column with the number of other rows with that date

select day_of_submission, sum(1) as [Count]
from my_table 
group by day_of_submission
share|improve this answer

Your Answer


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

Not the answer you're looking for? Browse other questions tagged or ask your own question.