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 |
|
jerds
Starting Member
1 Post |
 Posted - 2012-01-04 : 22:28:14
|
| Dear all,There is a group where there is a similar member(example C). The Grand Total becomes bloated since C is doubled. Please give answer as how to subtract the value of the 2nd group to the Grand Total. Both Group 1 Total and Group Total should remain as it is, only the grand total will be manipulated.Teams__________TargetGroup 1 Total______35___A_____________10___B______________5___C_____________20Group 2 Total______55___C_____________20___D_____________30___E______________5 Grand Total________80Thanks in advance. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-07 : 21:06:20
|
quote:
Originally posted by jerds
Dear all,There is a group where there is a similar member(example C). The Grand Total becomes bloated since C is doubled. Please give answer as how to subtract the value of the 2nd group to the Grand Total. Both Group 1 Total and Group Total should remain as it is, only the grand total will be manipulated.Teams__________TargetGroup 1 Total______35___A_____________10___B______________5___C_____________20Group 2 Total______55___C_____________20___D_____________30___E______________5 Grand Total________80Thanks in advance.
how is the data coming from the backend table?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
SSAS Editing Grand Total