Hi,
I have a scenario where I created a Webi report for various Countries vs Sales vs Weeks in a year.
I need to create a Line chart in Xcelsius such that when i select a Country , the Sales for all the weeks in a year is displayed in Line chart.
So I put a destination ( target ) no. of rows in Excel file and the imported the Crosstab tables (created in Webi) for Week nos. and Sales with Country as a Section. ( Using Live Office Connection) When the user selects the country the corresponding crosstab table should get populated into the Destination(target) no. of rows. I want to map that target no. of rows to Xcelsius Line chart component. So my question is Can i write a macros for populating the target rows depending on user selection and then go ahead and map it to Xcelsius? Is Xcelsius compatible with macros?? Please reply.
Here is a link to the sample report of what I have created.
http://spreadsheets.google.com/ccc?key=0ArtH2PxMq8GXdDVfeWtneEQ4eVIyY1BtSlpySzRaS2c&hl=en