Hi, Nasriyah here. I am trying to solve this report table format as Total Revenue is not displaying at the last column. How can I go about on solving this problem? much needed help here ~~
Total Revenue (highlighted in blue) should be displayed at the last Column
Solved! Go to Solution.
Nasriyah,
How does your workflow look like? Is the Total revenue row coming from a separate stream? If so, you can select the order in the union tool.
Alternatively, I assume the Total revenue will always be the highest value in the column, so you can sort it by value.
Hi Michal,
Thanks for the solution ideas, much appreciated.
Furthermore - in some cases (say for instance your blue row was an average instead of total) you can create a "sort" field using a formula, then simply sort the records before the reporting tool and not display that sorting field in the output.
[Sort] = IF IsEmpty([YourDateFields]) THEN 2 ELSE 1 END IF Sort by [Sort] ASC before the report tool, then simply don't use that field in the table.