Year to Month Calculation

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Dip <soumyadip.bhattacharya@xxxxxxxxx>
Date: Thu, 14 Jun 2007 01:01:17 -0700

Hello Expert,
My data table looks like below:

DIV Year MonthCode Month Actual Vendor
AA 2001 3 SEP-00 200
BANTHORP PTY LTD
AA 2001 4 OCT-00 100
DELTA SALES PTY LTD
BB 2001 5 NOV-00 100 D&F
ACCOUNTING LTD
CC 2001 6 DEC-00 100
BANTHORP PTY LTD

How do I calculate Year to Month for 2001 financial year (JUN-00 to
JUL-01)?
My Excel Pivot table report will have Vendor on Row & Division on
Column so that I can
analyse vendor by division for actual expenditure.

Please help, I got stuck.
Many thanks.
DP

.

Follow-Ups:
- Re: Year to Month Calculation
  - From: Ed Murphy

Prev by Date: Re: SQLLitespeed x64 intermittent failures
Next by Date: Transaction logs
Previous by thread: SQLLitespeed x64 intermittent failures
Next by thread: Re: Year to Month Calculation
Index(es):
- Date
- Thread

Relevant Pages

Year to Month Calculation with T-SQL
... BANTHORP PTY LTD ... DELTA SALES PTY LTD ... ACCOUNTING LTD ... analyse vendor by division for actual YTD expenditure. ...
(microsoft.public.sqlserver)
Re: Year to Month Calculation
... BANTHORP PTY LTD ... ACCOUNTING LTD ... How do I calculate Year to Month for 2001 financial year (JUN-00 to ... select Vendor, sum ...
(microsoft.public.sqlserver)