Find YTD

tyagishaila · ‎2014-12-11

what is the script to get YTD (Year Till Date)

YTD 13-14

YTD 12-13 and so on

e.g As today is 11 Dec,

YTD 12-13 means (01 April 12) to (11 Dec 13)

YTD 13-14 means( 01 April 13) to (11 Dec 14)

pick data for this time interval

tyagishaila · ‎2014-12-11

I want table in this form

Store Name YTD 11-12 (Member Count) YTD 12-13 (Member Count) F M # Members

F M # Members Overall 40% 60% 558,588 42% 58% 603,816 NORTH 44% 56%

145,166 45% 55% 165,081 DELHI 50% 50% 38,166 50% 50% 51,720 LS-Ambey Mall

Vasant Kunj Delhi 53% 47% 11,986 53% 47% 14,053

On Thu, Dec 11, 2014 at 12:22 PM, Bhawna Gupta <qcwebmaster@qlikview.com>

tyagishaila · ‎2014-12-11

Store Name	YTD 11-12 (Member Count)			YTD 12-13 (Member Count)
Store Name	F	M	# Members	F	M	# Members
Overall	40%	60%	558,588	42%	58%	603,816
NORTH	44%	56%	145,166	45%	55%	165,081
DELHI	50%	50%	38,166	50%	50%	51,720
LS-Ambey Mall Vasant Kunj Delhi	53%	47%	11,986	53%	47%	14,053

I want this type Pivot Table. There is also a problem that no. of members are shown after F and after M , not single time after F & M

tyagishaila · ‎2014-12-11

Actually all time I don't want today's date,

I want year wise slots,

day and month must be Today's date but Year should not be

e.g.

YTD(11-12) is 1/1/2011 to 11/12/2012

YTD(12-13) is 1/1/2012 to 11/12/2013

YTD(13-14) is 1/1/2031 to 11/12/2014

This is for sale comparison, if I am comparing my sale today, than last year sale must be compare from start date to till date on last year

otherwise comparison will be wrong.

I think You understand my requirement

tyagishaila · ‎2014-12-11