Question:
Hi All
I am using BW 3.0B. In BEx Report I have 3 characteristic as Division , Service, Traffic and Key figure as Amount.
while reporting i want the " Result as " string as "Service Total of A" ....etc
How to do that.
Eg.
Division Service Traffic Amt.
1001 A 120 $12005.56
A 130 $ 500.00
Service Total of A $12505.56
B 160 $12305.56
B 170 $1500.00
Service Total of B $13805.56
Division Total of 1001 $26311.12
Thanks in Advance.
Regards
Johnson Amalanathan
SAP BIW Project
Satyam Computer Services Ltd.
Galaxy No 97,
T.Nagar, Chennai - 600 017.
Ph: +91-44-8206120 Ext. 5768
E-mail: Johnson_Amalanathan@satyam.com
Answer:
Are you familiar with VBA for Excel? If so, it should be fairly easy to write some code that replaces the standard text with the one you would like to see (use project SAPBEXonRefresh).
Cheers,
El Belgio