Focal Point
[SOLVED] detailed columns total

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6157093516

January 13, 2012, 11:22 AM
K2R400
[SOLVED] detailed columns total
Hello,

I don't know how to create detailed columns total like below :


Year		2000	2001
-----------------------------------
Paris	CA	100	 110
	Marge	 30	  30	
	Budget	 20	  25

Londres	CA	120	 100
	Marge	 35	  30 
	Budget	 25	  25	

NY	CA	230	 200
	Marge	 30	  40
	Budget	 60	  70
-----------------------------------
TOTAL	CA	450	 410
	Marge	 95	 100
	Budget	105	 120
-----------------------------------


Is It possible with wf ?
Thank you in advance.

This message has been edited. Last edited by: Kerry,


WebFocus 7.7 (DB2 Web Query 1.1.2). IBM i
January 15, 2012, 04:06 PM
Waz
Yes.

The Macgyver technique will do it.

There are many posts on the subject, but in a nutshell, you effectivly duplicate the records in the report, but can assing one set to the totals and the other to the detail.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

January 16, 2012, 03:04 AM
K2R400
Thanks a lot.


WebFocus 7.7 (DB2 Web Query 1.1.2). IBM i