Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fasghari
Starting Member
1 Post |
 Posted - 2011-01-13 : 17:05:11
|
| Hi, I am trying to write a report that includes a Column chart. I have trouble finding out the right grouping expression for the Series part of this chart. Let's say I am sending the sales of all the employees to this chart. The data feild in the chart is "sales" in Dollars. The Category is "year(2007-2008-2009-2010)" and the series is employee's Gender. If I were to compare female to male I would just put Feilds.Gender.value in the chart series grouping expression and everything would be fine and I would get 2 columns one for "male" and one for "female" comparing the sales of each group. My Problem is that I want 1 Column for "female" and 1 column for "all". In other words, I want to show all sales by any employee compared to all sales by Female employees. I just can't come up with the right grouping expression. Could some one out there help please? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-01-16 : 06:22:09
|
| it would be great if you can show a screenshot of how you want chart to look------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Column chart Series conditional Grouping