Help YTD,MTD,QTD

[NavinReddy]

Hi community,

Could some help me

I want to know YTD,MTD,QTD

some one explain me with one example,im using persional edition

how can we use these and apply

with one excel sheet

Thanks in Advance

rohith

[NavinReddy]

Hi mohit,

i already gone through that i can't able to understand

if any some example

thanks,

rohith

[er_mohit]

ok then load this excel file

and in script write

LOAD

date(Date,'MMM-YYYY')AS DATE,

date(Date,'DD-MM-YYYY')AS Date,

MONTH(Date)as Month,

Year(Date) as Year,

     Sale

FROM

(ooxml, embedded labels, table is Sheet1);

and then use one bar chart for YTD

use dimension DATE for both bar chart

write expression

//YTD:

sum({<Date = {">=$(=YearStart(max(Date))) <=$(=max(Date))"},Year =, Month = >} Sale)

and one bar chart for MTD

Sum({<Date = {">=$(=MonthStart(max(Date))) <=$(=Monthend(max(Date)))"}, Year =, Month = >} Sale)

[tresB]

Learnt YTD, MTD, QTD here in general, Then to achieve the same in QV read this .

[NavinReddy]

Hi mohit,

Thank you very much

Plz find the attachment,let me know if i roung

Thanks,

rohith