Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I Have Data like this
Assign Date open open_date close close_date Isuue_status
12/4/2012 abc 11/4/2012 abc 12/4/2012 closed
Like this i have data for caculation of open : i use opendate
for calculation of close: i use close date
i need a pivot table with single date or month field across dates ie
Months Open_count close_count
Jan-12 12 10
feb-12 10 0
Like this i need one date field but for calculation of open_count we should use open date and close_count we should use close_count
Regards,
Madhukumara
Hi,
As per my understanding you want to select a period like a Month say Jan-2012 and you want to see the Open Count and Close Count for this period. So do one thing-
Table:
open,
open_date,
Isuue_status,
open_date as Date
concatenate
//same table
close,
close_date as Date ,
Issue_status
now select this Date field or link this to a calendar u ll get both open n clased data.
Thanks n Regards
Apurva
Hi,
How to link dates and same table we shoud concatenate?
regards,
madhukumara
On Fri, Jun 15, 2012 at 12:22 PM, Apurva ... <
Hi,
there is a keyword CONCATENATE use this. suppose your table name is A.
A:
load *,
open_date as Date
from A;
CONCATENATE
load *,
close_date as Date
from A;
regards
Apurva