Group Count Result (with totals)

[#1]

Hi,

I am counting a field (called TYPE) and the result is ok.

What I need is to list the the values of dimension and respective totals grouped by count result.

Count OK:

What I want:

Thank You!

[Gysbert_Wassenaar · Accepted solution]

See attached example. No idea how to get the lines for frequency 0 though.

[#3]

Nice.

I just added TIPO={'D'} and works fine!

count({<TYPE={'D'}, TYPE={'T'}>}DISTINCT COUNTRY)

//count({<TYPE={'T'}>}DISTINCT COUNTRY)

and after that, change set null symbol (tab presentation) the text: 0 Frequency