set analysis with dimension

[#1]

Hi,

I have a table with all the parts and as dimension the catergory of the parts and as expression the sum of the price of the parts.

Now I want to add an excel with expected sale sum per catergory.

I tried this:

sum( {$<CATERGORY= {"='${DIMENSION_FIELD_NAME}'"} >} EXPECTED_SALES)

[whiteline]

I think the correct syntax is:

sum( {$<CATERGORY= {"=$(DIMENSION_FIELD_NAME)"} >} EXPECTED_SALES)

But it depend on the value of DIMENSION_FIELD_NAME variable.

[#3]

It doesn't work.

The data is like this:

Table1:

PartName	PartCategory	PartValue	Week	Year
Part1	ABC	20	1	2012
Part2	DEF	10	1	2012
Part3	ABC	100	1	2012
Part4	DEF	90	2	2012
Part5	ABC	80	2	2012
Part6	DEF	90	2	2012
Part7	ABC	80	3	2012
Part8	DEF	20	4	2012
Part9	ABC	20	5	2012
Part10	DEF	10	5	2012

Table2 :

PartCategory	Budget	Week	Year
ABC	50	1	2012
DEF	50	1	2012
ABC	60	2	2012
DEF	60	2	2012
ABC	51	3	2012
DEF	51	3	2012
ABC	61	4	2012
DEF	61	4	2012
ABC	52	5	2012
DEF	52	5	2012

And if 1 select week 2 i want to see:

PartCategory	sumPartValue	Budget
ABC	80	60
DEF	180	60

[whiteline]

What is DIMENSION_FIELD_NAME ?

Why not to use just  Sum(Budget) as your tables are connected through PartCategory.

[thomas_skariah · Accepted solution]

Hi,

Find the attached application.

Hope this works.

Regards,

Tom

[#6]

Oh sorry, the 2 tables are only connected by week.

But I am going to try now to connect them by PartCategory.

[#7]

Thanks everyone, it seems to work correctly