Counting of Rows on Same Values
Hi, I have 2 tables Employee and Task. Each Employee has many Tasks and those Tasks are defined weekly. In the Task Table I am trying to capture the count of the tasks by Employee Name+Week Numb...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendI suggest that you use a Summary report. If you cannot get enough "group bys" (I think that the limit is 6) for the columns that you need, you can combined fields in a formula.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
- Hi Mark,
My problem is not a Summary Report or enough Group Bys. What i want to do is I would like to have a Count only on the one row for which the combination is the same and then i would like to insert those rows in another table.
For example if you have a look at the screen shot on the Top Grid QB Output you would see that Gunsham Lakhiani-14-Green shows Total Count 2 in both the rows but I want the Total Count 2 in any one row and then would like to add that in another table as below
Name Week Color Count
Gunsham Lakhiani 14 Green 2
I hope i am able to explain what i am trying to achieve.
Looking forward to hear from you.
Regards
Gunsham
------------------------------
Gunsham Lakhiani
------------------------------- MarkShnier__YouLet us not give up on the summary report approach quite yet. My point of making a summary report is once you have that you can use the MORE button to copy these records to another table. Can you tell me if there is a reason that approach will not work for you?
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- Hi Mark,
I do not want any manual intervention but it should be automated thru pipelines or any other way.
Thanx
------------------------------
Gunsham Lakhiani
------------------------------
