Multiple counts

[#1]

Hi All,

My data is like this:

Data:

Load * inline [

AcctNo,Status

1,A

2,B

3,B

4,D

5,C

6,B

7,A

8,B] ;

I want to show

Count({<Status='A'>}AcctNo)

Count({<Status='B'>}AcctNo)

Count({<Status='C'>}AcctNo)

Count({<Status='D'>}AcctNo) Output like below dynamically in a text box.

2 A

4 B

1 C

1 D

How to achieve this?

Thanks in advance.

[#2]

Yes, I tried. It is showing NULLs.

[sunny_talwar]

Did you try this?

=Concat({<Status = {'*'}>} DISTINCT AGGR(Count({<Status = {'*'}>} TOTAL <Status> AcctNo) & ' ' & Status,Status), Chr(10))

or are these not true nulls?