|
visakh16
Very Important crosS Applying yaK Herder
India
47023 Posts |
 Posted - 03/07/2012 : 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__________Target
Group 1 Total______35
___A_____________10
___B______________5
___C_____________20
Group 2 Total______55
___C_____________20
___D_____________30
___E______________5
Grand Total________80
Thanks in advance.
how is the data coming from the backend table?
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
 |
|
SSAS Editing Grand Total
