Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Analysis Services (2000)  need help with OLAP

Author  Topic  tyme Starting Member 10 Posts Posted - 2007-05-03 : 03:26:37 hi,i'm new to OLAP...i'm currently developing a report in the Excel...can we insert 1 data field into 2 column?..example, i have 1 data field called 'no. of application'...i want to include this data field into the pivot table and i want it to appear in 2 column where 1 column contain the actual value and 1 column in percentage. Please guide me with neccessary steps. Thank you. No. of application No. of application (%) 1 50 0 0 1 50 __________________________________________ Total 2 100