Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
I think the correct syntax is:
sum( {$<CATERGORY= {"=$(DIMENSION_FIELD_NAME)"} >} EXPECTED_SALES)
But it depend on the value of DIMENSION_FIELD_NAME variable.
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 |
What is DIMENSION_FIELD_NAME ?
Why not to use just Sum(Budget) as your tables are connected through PartCategory.
Hi,
Find the attached application.
Hope this works.
Regards,
Tom
Oh sorry, the 2 tables are only connected by week.
But I am going to try now to connect them by PartCategory.
Thanks everyone, it seems to work correctly