Sum based on attribute of input

RichardL

Hi All,

 

I am a beginner in Anaplan, just finished my training course and started building my first model. What I am trying to achieve here is to sum a column (input) based on each record's category (another input, formatted as list created previously). 

 

For instance, This is my input:

Value   Category

100         A

200         B

500         A

50           C

65           B

 

Note that I have created a list called category, and there are three items in that list (A B C).

I put the category in the page dimension so I can toggle. I did not have a line item called category.

 

What I would like to achieve is to add a total value column to show the total column of that category when I toggle that category.

Category: A

 

Value  Total-value

100         600

500         600

 

How can I achieve this? I tried Value[sum:Category] but it says it is not a line item. Should i create a property in the category list so i can use it in the formula?

 

Thank you so much!