Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

percent increase

2 posts in DataWindow Last posting was on 2009-08-27 13:56:01.0Z
MattN Posted on 2009-07-01 12:27:31.0Z
From: MattN <mjn1rar@gmailSPAM.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: percent increase
Message-ID: <fclm45hqvg2pncs8rol722fnqpudagbuom@4ax.com>
X-Newsreader: Forte Agent 4.2/32.1118
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 1 Jul 2009 05:27:31 -0700
X-Trace: forums-3-dub.sybase.com 1246451251 10.22.241.152 (1 Jul 2009 05:27:31 -0700)
X-Original-Trace: 1 Jul 2009 05:27:31 -0700, vip152.sybase.com
Lines: 9
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89570
Article PK: 418759

I need to display the percent increase of sales from one month to the
next in a crosstab dw and a graph dw..

What I cant work out is how to get the value of the previous month for
the above dw types..

Thanks

PB11.5


Chris Fauvel Posted on 2009-08-27 13:56:01.0Z
From: "Chris Fauvel" <Chris.Fauvel@gte.net>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <fclm45hqvg2pncs8rol722fnqpudagbuom@4ax.com>
Subject: Re: percent increase
Lines: 28
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a969071$1@forums-1-dub>
Date: 27 Aug 2009 06:56:01 -0700
X-Trace: forums-1-dub 1251381361 10.22.241.152 (27 Aug 2009 06:56:01 -0700)
X-Original-Trace: 27 Aug 2009 06:56:01 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89843
Article PK: 419031

I don't know how to do it solely inthe DW control or Object,but what about
the result set bring back these values for you?

I would hope that the DWs are based on a stored procedure rather than a sql
statement, or you could have a DW.UserDefinedmethod that does the work and
insert the values in the proper holding column

Jan$2009, Jan2009PCT_Diff, Feb$2009, Feb2009PCT_diff, etc

This assumes that the crosstab affect is actually done prior to the
DW...sorry this might not help.

I tend to do most of my work inthe stored procedure, including the
crosstab/pivot then simply display using a a simple DW

"MattN" <mjn1rar@gmailSPAM.com> wrote in message
news:fclm45hqvg2pncs8rol722fnqpudagbuom@4ax.com...
>I need to display the percent increase of sales from one month to the
> next in a crosstab dw and a graph dw..
>
> What I cant work out is how to get the value of the previous month for
> the above dw types..
>
> Thanks
>
> PB11.5