Add Columns "Total" and "Frequency" for collect tab

[Yaroslav Prokhorskoy]

Hi,

I have the next table made with collect table:

collect table priority1 priority2, statistic(proportion, across(priority2)) total(priority1) nformat(%6.3f) // nototal
collect label levels priority1 1 "Education" 2 "Food" 3 "Law" 4 "Infrastr" 5 "Underrep" 6 "Climate" 7 "Health" 8 "Pollution"
collect label levels priority2 2 "Food" 3 "Law" 4 "Infrastr" 5 "Underrep" 6 "Climate" 7 "Health" 8 "Pollution" 9 "Power"
collect title "`title'"
collect style cell border_block, border(right, pattern(nil))
collect style cell border_block, border( top, pattern(double))
collect preview
collect export "tab_a2.tex", append tableonly

Could I add two columns at the end showing the total count and fraction of the overall total, and also fill in zeros in the superdiagonal entries?

Thanks!