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 |
|
v_kash
Starting Member
45 Posts |
 Posted - 2013-08-28 : 13:57:05
|
| ok, so hopefully someone can answer this: i have a report, that is grouped by a store manager. to keep it simple, it has 1 column (but each column has a row for 'Commercial','Retail',Total'). What i want to do, is when they select 2 managers, to have the grand total of ONLY each person's total row. What is currently happening, is that it is adding Commercial + Retail + Total (for each manager). I want the grand total to ONLY select the value from the 'Total' Row. I've tried conditional expressions, but to no avail |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-08-29 : 03:48:02
|
| =SUM(IIF(Fields!CategoryField.value="Total",Fields!YourDataField.value,0))where categoryfield is one having values Commercial,Retail etc and data field has actual values.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|
|
SSRS 2008 - Adding Grand Totals