Thanks in advance for any help,
I have been working on this problem for a while and cannot seem to find a solution. I have an email template workflow that sends a report from my “Query_Data” table. In my template, I use this formula <<START:ORDERBY(SELECT(Query_Data[_ComputedKey],AND([Year]=[_THISROW].[Year],[Month]=[_THISROW].[Month],[Day]=[_THISROW].[Day],[company]=[_THISROW].[Company],[farm]=[_THISROW].[Farm],[crop]=[_THISROW].[Crop],[Field Type]=[_THISROW].[Field Type])),[crop],true)> I would like to switch the rows and columns, the same way you would use TRANSPOSE in sheets. In the format I have now, I have to use multiple tables to fit all the columns and it causes the PDF to be multiple pages and difficult to scroll.This is how I have it set up now:
User | Count |
---|---|
42 | |
33 | |
24 | |
23 | |
14 |