Count same values in tables like countif or sum function

Question

I really dont know why some basic functionalities cannot be provided in confluence but i have following question:

For instance, i have a table with one column (A) and 3 rows

Now i would like to have an overview above this table that counts how often Product Y is listed in column A, and how often product X is listed in column A.

A

1  Product Y
2  Product Y
3  Product X

In a perfect world, the result would be:

Product Y: 2 <- im looking for this macro/functionality that shows me this number

Product X: 1

How does it work without having to buy add-ons (restrictions).

Im looking forward for your responses.

Best regard

ED

Edward Griffith · Answer

unfortunately paid add-ons are not possible due to restrictions. It'd be too expensive.

Are there any other workarounds for implementing such a number?

Edward Griffith · Answer

Thanks for your answer Andrey

Andrey Khaneev _StiltSoft_ · Answer

Hello Ed,

It is possible to do with Pivot Table macro, but Table Filter and Charts is a paid add-on.