Forum Discussion

MarkShnier__You

Icon for Qrew Legend rank

Qrew Legend

Re: Counting of Rows on Same Values

I 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)
[email protected]
------------------------------

8 Replies

GunshamLakhiani
Qrew Cadet
4 years ago
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__You
  Qrew Legend
  4 years ago
  Let 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)
  [email protected]
  ------------------------------
  - GunshamLakhiani
    Qrew Cadet
    4 years ago
    Hi Mark,
    
    I do not want any manual intervention but it should be automated thru pipelines or any other way.
    
    Thanx
    
    ------------------------------
    Gunsham Lakhiani
    ------------------------------