Query As A WEb Service

[system]

Hi,

I had a question regarding QAAWS.

I have created a query using QAAWS and mapped the input and output columns to the excel spreadsheet.

However, I want the excel spreadsheet table to be a crosstab and not a regular table.

Is there a way to slice and dice …so as to come up with a crosstab in excel and then load the same in xcelsius??

Thanks

---

zephyrous (BOB member since 2007-01-12)

[system]

Please refer to this topic

Xcelsius and Proper Use of QaaWS

Hi everyone, I’m using Xcelsius 2008 w/ QaaWS, and have a query about proper usage, specifically with selectors. I have three columns of data, Year, Quarter and Sales (from eFashion of course!) =) Yr Qtr Sales == === ==== 01 Q1 100 01 Q2 200 02 Q1 500 02 Q2 70 I want to put this data into a cross-tab format within the Excel spreadsheet, so that I can use row selectors to make the chart dynamic. So the data would look like this: Q1 Q2 01 100 200 02 500 70 Can anyone describe how to …

I hope this would help…

---

siauan (BOB member since 2008-04-14)