aggr Set Analysis

[andrea90casa]

I have this situation:

Name	Year	Category	Value
Alfa	2015	Cat_01	1000
Alfa	2014	Cat_01	800
Alfa	2013	Cat_01	900
Gamma	2015	Cat_02	1500
Gamma	2014	Cat_02	2000
Beta	2015	Cat_01	1400
Epsilon	2014	Cat_01	800

And i would like to create a chart with Year as dimension and then the total amount of value by category. For example if i select Alfa i would like to obtain (in this case the category will be Cat_01):

2015) 2400

2014) 1600

2013) 900

I tried to write this formula:

Aggr(nodistinct sum({<Name>} Value),Category)

But if i do this it gives to me the entire value wihtout considering Year fields.

How can i solve this problem?

Andrea

[swuehl · Accepted solution]

Try using Year as dimension and as expression

=Sum({<Category = p(), Name= >} Value)

[andrea90casa]

Thank you Stefan,

I will go to see what is that p() and how it works

Andrea