I have the next problem and I can't find how to fix.. please can anybody help me?, I did three tables
Table: Group
Fields: Pk_group(N), group(CH)
Table: Week
Pk_week(N), Week(CH), Fk_group(N)
Table: Detail
Fields: Pk_detail(N), Product (CH), Cant, (N), Fk_week(N)
And I did a Set: Group(1:N)Week, Week(1:N)Detail, And after I made a report, using the set, with this structure (by groups and by week)
My field "Total", is adding the total of column and I don't need the total by column, I need that the sum must be by week like the example I've wrote here, the week number 1 have a Total of 30, the week number 2 have a Total of: 130, �how can do this using calculated fields in a report?,..
.. really I'm sorry for my English, I hope can understand my explication.
note: the field "Cant" is a calculated field into the report.
I have this now..
Group: A, Cant: 30, Total: 170
Week: Number 1
Product Cant
prod1 10
prod2 20
-----------------------
Group: A, Cant: 100, Total: 170
Week: Number 2
Product Cant
prod3 50
prod4 50
-----------------------
Group: A, Cant: 40, Total: 170
Week: Number 3
Product Cant
Prod1 20
Prod3 20
And I want this..
Group: A, Cant: 30, Total: 30
Week: Number 1
Product Cant
prod1 10
prod2 20
-----------------------
Group: A, Cant: 100, Total: 130
Week: Number 2
Product Cant
prod3 50
prod4 50
-----------------------
Group: A, Cant: 40, Total: 170
Week: Number 3
Product Cant
Prod1 20
Prod3 20
Table: Group
Fields: Pk_group(N), group(CH)
Table: Week
Pk_week(N), Week(CH), Fk_group(N)
Table: Detail
Fields: Pk_detail(N), Product (CH), Cant, (N), Fk_week(N)
And I did a Set: Group(1:N)Week, Week(1:N)Detail, And after I made a report, using the set, with this structure (by groups and by week)
My field "Total", is adding the total of column and I don't need the total by column, I need that the sum must be by week like the example I've wrote here, the week number 1 have a Total of 30, the week number 2 have a Total of: 130, �how can do this using calculated fields in a report?,..
.. really I'm sorry for my English, I hope can understand my explication.
note: the field "Cant" is a calculated field into the report.
I have this now..
Group: A, Cant: 30, Total: 170
Week: Number 1
Product Cant
prod1 10
prod2 20
-----------------------
Group: A, Cant: 100, Total: 170
Week: Number 2
Product Cant
prod3 50
prod4 50
-----------------------
Group: A, Cant: 40, Total: 170
Week: Number 3
Product Cant
Prod1 20
Prod3 20
And I want this..
Group: A, Cant: 30, Total: 30
Week: Number 1
Product Cant
prod1 10
prod2 20
-----------------------
Group: A, Cant: 100, Total: 130
Week: Number 2
Product Cant
prod3 50
prod4 50
-----------------------
Group: A, Cant: 40, Total: 170
Week: Number 3
Product Cant
Prod1 20
Prod3 20
Comment