Hoe to move a row to bottom based on a text in the Reporting palette "Table" Macro

[Anudeep_Yalamuru]

Hi All,

I have a table like below.

How can I move the row that contains "Total" to the last row while building the table using "Table" Macro from Reporting Palette.

Please provide your feedback.

Thanks

[aatalai]

Before the table tool Filter out the total with  !contain([description],"Total") then unioning the the outputs from the filter outputs, with the true being at the top let me know how you get on

something like this

[AndrewDMerrill]

I recommend sorting the data into desired format prior to using the Table Tool. You can do this by adding a Formula Tool creating a new column set to:
IIF(StartsWith([Description],"Total"),2,1)

Then sort on this column just before the Table Tool.

Hope this helps and Happy Solving!