YTD, QTD & MTD Calculations

[hkg_qlik]

Hi,

I am trying to build a report Daily Sales Report as below:

Example: I want to create a date prompt where user can select a Date depending on which the below mentioned report should change.

Here is the details of the Dimension & Fact I am using for the report:

TABLE: REVENUE_FACT (Data Warehouse)

BRANCH,
CUSTOMER,
CUST NO.,
SALES,
INVOICE DATE,

TABLE: TIME_DIMENSION

CALENDAR_DATE,
CALENDAR_MONTH,
CALENDAR_QUARTER,
CALENDAR_WEEK,
CALENDAR_YEAR

DIVISION	BRANCH	CUSTOMER NAME	CUST. NO	DAILY SALES	TONS	(YTD.SALES)	(QTD.SALES)(	MTD SALES)
1	A	AB	100	1000	2
1	B	BC	101	2000	5
2	C	CD	102	3000	7
3	D	EF	501	4000	9
2	C	GH	502	5000	10
3	D	HI	1000	10000	20
4	E	JK	1001	11000	13
4	E	LM	1002	12000	12
5	G	OP	5000	3000	11

[mike_garcia]

Hi!

Give this a read: http://iqlik.wordpress.com/2010/11/27/the-magic-of-set-analysis-point-in-time-reporting/

Mike.