cutting/ pasting columns from one layer to another

[steever]

Hi,

I have a report with a bunch of time categories as layers (eg. March 2003, April 2003). Within each layer their is an Opening Balance, Sales, Debits, and Closing Balances. I'd like to be able to take a subset of these layers (a fiscal quarter for eg.) and create a summmary layer for these.

I'm able to produce this (PPRep.Layers.Subset(1,2).Addition) summary layer which is GREAT, however, I dont want ALL the columns added up. I only need the Sales and Debits Columns added up. I really want to have the Opening Balance value from the first layer in the range, and the Closing Balance value from the last layer in the range (presently they are accumulating the values for the Balance columns across each column in the range) in my Summary layer.

Is there a way (or a workaround) by which i can bring a single column into another layer without having the values change. Its like i just want to cut and paste the column, but when I do this it will inevitably change all the values given that its being nested under the new levels/categories in the new (summary) layer. This seems like it should be such an easy thing to do, and difficult to explain to non-tech people (our clients) why it isn't so easy !

Any ideas out there ??

Hope this makes sense .. and, thx in advance.

Steve

 

[GJParker]

I don't think tour going to get this kind of functionality in powerplay it just isn't this clever. Ypu could try Impromptu but even then i think you would struggle to achieve what you need.



Gary Parker
Systems Support Analyst
Manchester, England

 

[steever]

Gary,

Thx for the response. D'ya think there may be any potential
workaround to this problem. Create 2 reports - 1 with the column, 1 with all the other columns, then dump them all out to Excel, maybe. I'm a little leary of throwing it out
to Excel and getting into a 'formatting nightmare' but we're on the hook to provide something even if it isn's as pretty as they'd hoped.

Any ideas?

cheers.

S