Anybody aware of this problem? Any solution ?
I am using Ms Excel 2003( with Office Service pack 1) to create an OLAP pivot table, contain product as dimension, first level is product group, second level is product class and third level is product type. Budget volume , sort sequece1 and sort sequence 2 as measurement. Sort sequence 1 and sort sequence 2 are calculated member in the cube.
I wanted to sort product group by sort sequence 1 and sort product class by sort sequence 2. Below was the step I did.
Right clickField Settingadvanced auto options choose ascendingusing fields choose sort sequence 1
Same step repeat to sort product class.
But data did not sort properly. I try not to use calculated member as sorting key, data was sorted properly
[/b]
I am using Ms Excel 2003( with Office Service pack 1) to create an OLAP pivot table, contain product as dimension, first level is product group, second level is product class and third level is product type. Budget volume , sort sequece1 and sort sequence 2 as measurement. Sort sequence 1 and sort sequence 2 are calculated member in the cube.
I wanted to sort product group by sort sequence 1 and sort product class by sort sequence 2. Below was the step I did.
Right clickField Settingadvanced auto options choose ascendingusing fields choose sort sequence 1
Same step repeat to sort product class.
But data did not sort properly. I try not to use calculated member as sorting key, data was sorted properly
[/b]
