Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] SUBHEAD SUBTOTAL or SUBFOOT SUBTOTAL
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] SUBHEAD SUBTOTAL or SUBFOOT SUBTOTAL
 Login/Join
 
Guru
posted
IS it possible to take total of 4 columns in one row in accordian report in subheading or subfooting.

I have accordian report:
BY DIVISION
BY DISTRICT
BY STORE

I want DIVISION to show DIVISION LEVEL SALES TOTALS
WHEN USER EXPANDS DIVISION IT SHOULD SHOW DISTICTCT and STORE LEVEL DETAILS
FOR EXAMPLE
/*
+DIVISION1 P1 p2 P3
1000 2000 1500
+DISTRICT1 500 1200 800
+STORE1 500 900 700
+STORE2 0 300 100
+DISTRICT2 500 800 700
+Store x x x
/*

Is it possible?

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


WebFOCUS 7.6.10
Windows
HTML
 
Posts: 294 | Registered: March 04, 2010Reply With QuoteReport This Post
Expert
posted Hide Post
Hi Arif,

The following online document may be of interest:

How to produce a Summary level Accordian Report

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
 
Posts: 1950 | Location: New York | Registered: November 16, 2004Reply With QuoteReport This Post
Gold member
posted Hide Post
COl1 ONE TWO THREE FOUR subt1 subt2
---- ---- --- ----- ------
A 10 10 10 10 N N
B 5 5 5 5 Y N
C 3 3 3 3 Y N

E 10 9 8 6 N Y
F 8 8 8 8 N N
SUB_CALC 10 9 8 6

Create Another two Colomns like subt1, subt2 and Assign value 'Y' or 'N' depends on the colomn.
in Print Statement for subt1, subt2 Columns use NOPRINT

Ex: subt1/A1 = IF COL1 EQ 'B' THEN 'Y' ELSE IF COL1 EQ 'C' THEN 'Y' ELSE 'N';
Ex: subt2/A1 = IF COL1 EQ 'E' THEN 'Y' ELSE IF COL1 EQ 'F' THEN 'Y' ELSE 'N';

ON RECAP
SUB_CALC= subt2 subt2

ON SUBFOOT
SUB_CALC




Env Prod:WebFOCUS 7702 ,Windows xp on 64, SQL Server 2008, IRF Tool
Env 1 Local: DevStudio 7702 - MS Windows XP SP2 - Apache Tomcat 5.0.28
Output: HTML, Excel and PDF
 
Posts: 52 | Location: NJ,USA | Registered: May 26, 2004Reply With QuoteReport This Post
Guru
posted Hide Post
quote:
How to produce a Summary level Accordian Report

Link provided above is good but its expanding too much for every level.


WebFOCUS 7.6.10
Windows
HTML
 
Posts: 294 | Registered: March 04, 2010Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] SUBHEAD SUBTOTAL or SUBFOOT SUBTOTAL

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.