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?

Thanks,

link|improve this question

feedback

1 Answer

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.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

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