Count same values in tables like countif or sum function Edited

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

2 answers

Hello Ed,

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

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?

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published May 17, 2018 in Confluence

Color tables for a shiny Confluence page

...; ## Developed by: Alana Fernando ## Shared with love ## @param style:title=style type|type=enum|required=true|desc=Choose a style.|enumValues=Style1,Style2,Style3,Style4,Style5 ## @param alignment:title...

383 views 17 18
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you