I created a report from a table named "Product_Order" with the following fields
secret_code
mem_name
mem_code
mem_chapter
trn_date
ar_no
or_no
pro_category
pro_sub_category
pro_code
pro_name
pro_qty
pro_cost
pro_price
total_cost
total_price
pay_mode
pay_terms
process_by
deliver_by
Now i needed to show report based on a group
NOTE: RC = REPORT COLUMN
Group 1 - Pro_Category: Has field "Pro_Category"
Group 2 - Pro_Name: Has the following fields below
RC 1 - Field: pro_sub_category
RC 2 - Field: pro_code
RC 3 - Field: pro_name
RC 4 - Formula Field: sum({product_order.pro_qty},{product_order.pro_name})
RC 5 - Field: pro_cost
RC 6 - Field: pro_price
RC 7 - Formula Field: {product_order.pro_price}-{product_order.pro_cost}
RC 8 - Formula Field: {product_order.pro_cost} * Sum ({product_order.pro_qty}, {product_order.pro_name})
RC 9 - Formula Field: {product_order.pro_price}*Sum ({product_order.pro_qty}, {product_order.pro_name})
RC 10 - Formula Field: RC9 - RC8
Task i can't do:
Summarize RC8, RC9 & RC10 based on Group 1 - Pro_Category.
Summarize ALL RC8, RC9 & RC10 - "Like a GRAND TOTAL SUMMARY"
In short i needed to summarize a summarized field.
You may see and download database file and screen shot at:
<ahref>https://dl.dropbox.com/u/65392916/SAMPLE.zip[
^]
Hope this is clear enough to understand.