Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to show only a subset of records in a straight table

I have a table like this

YearDeptAward
2011Finance3
2011HR2
2011HR2
2011Sales2
2012Finance2
2012Finance2
2012HR2
2012Sales1
2012Sales2
2012Finance1

I am trying to setup dashboard for different department.

How do I display a table that shows only data for specific group, e.g. only Sales data using Set Analysis?

YearDeptAward
2011Sales2
2012Sales1
2012Sales2
10 Replies
Anonymous
Not applicable
Author

Thanks everyone for the answers !