Forum Discussion

Del's avatar
Del
Qrew Cadet
5 years ago

Flip Report, Transpose

Trying to flip or transpose a table report. I have a simple one to many relationship and a simple table report but grouped by a date field - 'week'.

I want to create a table report but one that is flipped horizontally with the child records appearing as rows instead of columns.




------------------------------
  • well, you could copy to Excel and then edit paste (all)
    then edit paste special transpose into a new sheet

    But other than that, wow, that is a hard one.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • Del's avatar
      Del
      Qrew Cadet
      Tried to find how to do this everywhere but failing miserably. Hope this can be a native feature soon

      ------------------------------
      --------
      • DonLarson's avatar
        DonLarson
        Qrew Elite
        Phil,

        It sounds easy but is actually a completely different report.   Excel makes it looks simple but the spreadsheet is not really a reporting system, we just make the cells line up to be pleasant on the eye.

        Do you have any BI/BA tools like Tableau or Power BI?  We can get the data out of QB and then put an embedded report from one of those into Quick Base.

        ------------------------------
        Don Larson
        Paasporter
        Westlake OH
        ------------------------------