Expression

[upaliwije]

In my Pivot Table I have dimension field 'NOTE' ranging from 100 to 1000. I was to sum my fact field limiting note from 500 to 800 . Pls help me how to write this expression

[israrkhan]

try like this,

Sum({<NOTE >=500 <=800>}FactField)  or

Sum({<NOTE >=500, NOTE <=800>}FactField)

[upaliwije]

it is not working

Sum({<NOTE >=500, NOTE <=800>}BUDGET)

[israrkhan]

i think your field is text.

try like below

Sum({<NOTE >= {'500'}, NOTE <={'800'}>}BUDGET)

make sure NOTE is is Note. caps

[#5]

try this

Sum({<NOTE={'>=$(500)<=$(800)'}>}BUDGET)