table-render | 基于 FormRender 的中后台表格解决方案

my first SO question!

I am trying to order the result of a call to tabyl from the janitor package. I can't work out how to sort the numbers appended in adorn_ns().

Using tabyl, I managed to create a table with frequencies, proportions and totals with the below code. What I would like to achieve is to sort the table in descending frequency of the "Total" column. Ultimately, I would like to pass the table on to knitr's kable() for reporting.

After I've called arrange on the tabyl, adorn_ns() pastes the N's in the incorrect "original" position, instead of the sorted position. This has been noted in Github, and (as I understand it) is caused by the 'core' not changing when the tabyl is sorted. See: https://github.com/sfirke/janitor/issues/352

The comment on Github states: "This is not a critical problem, you can feed custom Ns to the adorn_ns() call where you do the sort there too." Unfortunately I can't figure out how to place these custom Ns.

Alternatively, I thought about changing the order by using factor, however I'm hoping for a more robust solution as this variable contains many categories in my real data, and I would like to be able to apply this (or an alternative) method of table-rendering to different variables in the future, without having to laboriously type out the levels by frequency.

SO, any help on custom Ns, alternative sorting methods or (if turns out to be necessary) alternative table methods is very much appreciated.

Here is some toy data and where I got stuck.