I need to create a excel report in lotusscript which consists of multiple pivots on the same work sheet named "Summary". All these pivots will use the first work sheet called "Data Entry" as the data source.
I was able to create the first pivot on summary sheet using the method:
xlsheet.pivottable wizard(1,"Data Entry!R3C1:R" + Cstr(i) + "C9", "Summary!R16C1","Pivot1")
When i try to create the second pivot using the follwing statement, it pushes the columns and rows of the first pivot and creates a new pivot deleting the first pivot, although i have specified a new column on the summary sheet as the destination for the second pivot (C8)
xlsheet.pivottable wizard(1,"Data Entry!R3C1:R" + Cstr(i) + "C9", "Summary!R16C8","Pivot2")
Please help, this is very urgent, needs to be done in two days time.................