how to create a YTD visualization ?

[#1]

How to make a visualization showing YTD Sales of each Salesman.

[maxgro · Accepted solution]

LOAD

     InYearToDate(MakeDate(Year,Month), Today(), 0) as YTD,

     Year,

    Month,

     Product,

     Sales,

     Salesman,

     Area,

     Count

FROM

RobSalesFact.csv

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

or this (same expression), dimensions YearMonth and Salesman

[#3]

thanks a lot.

but my requirement is like, the bar chart should not affect when i select any year or month.

the chart should respond to only selection of columns other than year and month.

[PrashantSangle]

Hi,

Nullify the field which you want not to affect on expression

like

Sum({<YTD={"-1"},Year=,Month=>}Sales)

Regards

[#5]

hey ! it works

thanks alot