I have a Cross Tab like the sample. The period have this fromula:
pack = TotalUnitsSoldMonth / UnitsPack
Units = TotalUnitsSoldMonth mod UnitsPackI need that
total column have not the sum of packs and units by period but yes the total of totalUnits at all periods with this formula:
Totalpack = TotalUnitsSold / UnitsPack
TotalUnits = TotalUnitsSold mod UnitsPack
|
|
Month 1
|
Month 2
|
Total
|
Must be
|
|
Products
Descrip
|
Packs
|
units
|
packs
|
units
|
packs
|
units
|
packs
|
units
|
|
Product 1
6 x 500
|
6
|
5
|
2
|
4
|
8
|
9
|
9
|
3
|
|
Product 2
12 x 250
|
4
|
4
|
5
|
8
|
9
|
12
|
10
|
0
|
Edited by arsinfo - 28 Apr 2011 at 2:21am
IP Logged