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)

[#2]

This works;

sum( if(CATERGORY= DIMENSION_FIELD_NAME, EXPECTED_SALES))

But it seems it's ignoring the selection so I get the total expected sales per catergory.

And when I add something after it like: AND SALES_WEEK = SELCTED_WEEK

It has no effect