Creating some new dimension/measure out of a specific dataset
I think this is a very basic question, but I do not see the tree in the woods.
I got this set uploaded with excel
|Country||Typ||Year 2005||Year 2010|
What I want to do is to create a new measure that contains the SUM and the average of this set. The specific thing is I just want it for the types (A, B and C).
That means my result should look in the end like this:
|SUM||Year 2005||Year 2010|
|Year 2005 (already possible)||648|
|Year 2010 (already possible)||1036|
Is this possible or do I need to rearrange the table itself so I got for each specific typ an own column?