Calendar

[smilingjohn]

Hi all,

I have a bar chart ...

I need to show total 13 bars (Jan,Feb,Mar,app,may,Jun,jul,Aug,sep,Oct,Nov,dec ,ytd)

Please need help to achieve this ...

In dimension iam using

Month field

And in expression iam using

Sun(sakes)*sum(expenses)/sum(profit)

Need your help expertise ..

Thanks in Advance

[karthikoffi27se]

Hi John

Format it using date function.

Date#(Date("Month field",'MMM'),'MMM') AS DateField

Use the above expression in chart and let me know what you get.

Many Thanks

Karthik

[smilingjohn]

Hi Karthik

I iam getting month against expression ...

Buy I need the last bat to display ytd ..which I am not able to get ...

I do have master calendar also ....and I have date field "date"

And it's format is MM-DD-YYYY