How to make a visualization showing YTD Sales of each Salesman.
InYearToDate(MakeDate(Year,Month), Today(), 0) as YTD,
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
or this (same expression), dimensions YearMonth and Salesman
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.
Nullify the field which you want not to affect on expression
hey ! it works
Retrieving data ...