Hello -
I am wondering if it is possible to create running sums across two different groups on the same report.
I have a report in which I would like the tote cube column to increase as picks are added and the module cube column to decrease as picks are added. I do want the running sum for the tote cube to reset with each new tote ID. However, I do not want the module cube to reset with each new tote ID but rather with each new module.
I'm sure this explanation is very confusing so I am attaching a sample of the database I am working on and also a JPG image of the report showing how I would like it the work.
Would someone please tell me if this is possible? I have been working on trying to figure this out for quite some time. :banghead:
Any suggestions are appreciated.
I am wondering if it is possible to create running sums across two different groups on the same report.
I have a report in which I would like the tote cube column to increase as picks are added and the module cube column to decrease as picks are added. I do want the running sum for the tote cube to reset with each new tote ID. However, I do not want the module cube to reset with each new tote ID but rather with each new module.
I'm sure this explanation is very confusing so I am attaching a sample of the database I am working on and also a JPG image of the report showing how I would like it the work.
Would someone please tell me if this is possible? I have been working on trying to figure this out for quite some time. :banghead:
Any suggestions are appreciated.