Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi community
I am trying to create a calculted field which shows only cost centres >= 9950 and <=9960.
1. The total range of numbers available are 0000 to 9999
2. The pivot table needs to show only cost centres including 9950-9960
3. I have tried the following; CostCentreName >=9950 <=9960 but returns this message in the field '//Error in calculated dimension
Any ideas will be very much appreciated.
Andy
Aggr(only({<[Cost Centres] ={">=9950 <=9960"}>} [Cost Centres]),[Cost Centres])
Aggr(only({<[Cost Centres] ={">=9950 <=9960"}>} [Cost Centres]),[Cost Centres])
Thank you Kevincool. in time for me to get this sorted before I finish for the day.
Thanks again.