Hi all,
I have a problem with the calculations at section levels.
There are 3 sections in the following herierchies at section level.
Region -> Location ->commodity.
In the table i have fields like Product Name,Qty Sold,Unit price and a variable Total Cost(Qty sold * Unit price)
i inserted a sum for Total cost.Now the catch is when i copy the same SUM field to section level(Commodity section) the value changes.I want to display the same Value which is shown in SUM(<Total Cost>) in table in Commodity section.
The value is displayed correctly when i have only 1 row in the table at the commodity section level,if there are more than 1 row then incorrect result.
REgion : East(section)
Location : Newyork(section)
Commoidty: xyz-Tshirt(section) Incorrect Sum(Totalcost)
Product N.o |Qty Sold | Unit price | Total Cost
Row1 abc 2 $ 10 $ 20
Row2 xyz 4 $ 40 $ 160
----------------------------------------------------------
Sum : $180
I want to calculate the sum total cost at all the 3 section levels .
I have a problem with the calculations at section levels.
There are 3 sections in the following herierchies at section level.
Region -> Location ->commodity.
In the table i have fields like Product Name,Qty Sold,Unit price and a variable Total Cost(Qty sold * Unit price)
i inserted a sum for Total cost.Now the catch is when i copy the same SUM field to section level(Commodity section) the value changes.I want to display the same Value which is shown in SUM(<Total Cost>) in table in Commodity section.
The value is displayed correctly when i have only 1 row in the table at the commodity section level,if there are more than 1 row then incorrect result.
REgion : East(section)
Location : Newyork(section)
Commoidty: xyz-Tshirt(section) Incorrect Sum(Totalcost)
Product N.o |Qty Sold | Unit price | Total Cost
Row1 abc 2 $ 10 $ 20
Row2 xyz 4 $ 40 $ 160
----------------------------------------------------------
Sum : $180
I want to calculate the sum total cost at all the 3 section levels .