Forum Discussion

AweMaggie's avatar
AweMaggie
Qrew Trainee
3 years ago
Solved

How to add more rows for Group by for a summary report?

I want to add more rows.  Any idea on how to do it? 



------------------------------
Aweke (DACL) Wudineh
------------------------------
  • Np,
    The limit is 6 group bys.  But just make some concatenated formula fields to combines some fields. That will free up some more levels.

    Like 


    List(" ", [Field 1], [Field 2])




    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------

4 Replies

  • Np,
    The limit is 6 group bys.  But just make some concatenated formula fields to combines some fields. That will free up some more levels.

    Like 


    List(" ", [Field 1], [Field 2])




    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • AweMaggie's avatar
      AweMaggie
      Qrew Trainee
      Awesome.  

      Thank you sooooooo much for your quick response, Mark!

      ------------------------------
      Awe Maggie
      ------------------------------
    • AweMaggie's avatar
      AweMaggie
      Qrew Trainee
      Sorry Mark, is it possible to get the field name on the report instead of the response?  What I am trying to say is
      For example I have a Yes/No question, so on the report can I get the actual question then with the number of Yes/No response?

      ------------------------------
      Awe Maggie
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Qrew Champion
        I think it would help to see what a record looks like and have an explanation of what you are trying to do with this report.

        ------------------------------
        Mark Shnier (YQC)
        mark.shnier@gmail.com
        ------------------------------