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 |
|
Halcyon
Starting Member
1 Post |
 Posted - 2009-03-05 : 11:10:19
|
| I am currently trying to create a report which brings in: Brand,Year,sum(Volume),sum(Net),sum(GP)Within the table I create a group on Brand, then another on Year...I would like to calculate the Growth or % Variance from one year to the next within the table and was wondering if this was possible using something similar to (Me.Value or ReportItems!textboxA.Value) or if there was another way without creating a derived table for each Year since some brands have longer history than others? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-03-10 : 04:28:19
|
| i think you need to bring these values also calculated from query by means of correlated subqueries |
 |
|
|
|
|
|
Growth Rate and Percent Variance within a Table