I have created one calculation context :
Let say i have following field in the DP ,
and in the block i have the following fields :
Year, state, revenue .
Now i have created one column to calculate the max revenue in the quarter for that year.
I have written the following formula
MAX( [REVENUE] FOREACH [ QUARTER] ) IN ([YEAR]).
but when i execute the report , i am getting the text with the formula.
Pls help me.....