Show Last 18 Months Data

[ashishpalkar]

Hi There

I have requirement like below , in below table we can see Time Period. I want to show Time Period as Columns and show respected revenue for that time period.

No	RLTV_MNTH	Time_Period	Total Revenue($)	Header 4	Header 4
PM0	0	Apr 2015	$100	a	q
PM(1)	-1	Mar 2015	$200	a	q
PM(2)	-2	Feb 2015	$100	a	q
PM(3)	-3	Jan 2015	$100	a	wq
PM(4)	-4	Dec 2014	$100	a	eqe
PM(5)	-5	Nov 2014	$100	a	qwe
PM(6)	-6	Oct 2014	$100		qe
PM(7)	-7	Sep 2014	$100	s	q
PM(8)	-8	Aug 2014	$100	s	eqwe
PM(9)	-9	Jul 2014	$100	s	q
PM(10)	-10	Jun 2014	$100	s	eq
PM(11)	-11	May 2014	$100	s	weq
PM(12)	-12	Apr 2014	$100	fs	eq
PM(13)	-13	Mar 2014	$100	ff	we
PM(14)	-14	Feb 2014	500	d	qwe
PM(15)	-15	Jan 2014	600	f	qe
PM(16)	-16	Dec 2013	700	f	qe
PM(17)	-17	Nov 2013	800	f	q

Required Output Needed

No	Header 4	Header 5	Total Revenue	Jan 2014	Feb 2014	Mar 2014	Apr 2014	May 2014	Jun 2014	Jul 2014	Aug 2014	Sep 2014	Oct 2014	Nov 2014	Dec 2014	Jan 2015	Feb 2015	Mar 2015	Apr 2015	May 2015	Jun 2015
PM0	A	www	$6831.07	$4387.76	$2443.31	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Pm1	Ba	2ad	$390.13	$269.75	$120.38	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Pm2	ww	assas	$2586.71	$1516.37	$1070.34	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

Thanks in advance.

[Qrishna]

use Crosstab() function.

Or in a pivot table u can pivot the period column.

Provide some sample data.

[awhitfield]

Hi Ashish,

a simple pivot chart would do the trick !

HTH - Andy