Count like pivot table

[#1]

Count like pivot table

I have the following data:

Item	in stock
A	4
B	4
C	4
D	3
E	3
F	3
AB	3
AC	3
AD	2
AE	2
B	2
B1	2
B2	2
B3	2

I like to count how many items I have for each count

This is my expected output

Count of Item
in stock	Total
1	10498
2	153
3	5
4	3
(blank)
Grand Total	10659

It’s easy using excel, I like to do the same on the QV.

Suggestions are more than welcome.

Thanks in advance.

[jvitantonio]

HERE YOU GO

[#3 · Accepted solution]

is the in stock an expression? You could try aggr like

count(aggr(sum(instock),Item))

[#4]

thank you both.