Skip to Content
0
Former Member
Sep 20, 2010 at 06:33 PM

Crystal graph

15 Views

Hello, experts!

I am trying to create a Bar Chart in Crystal which would show the following:

fluctuation of amounts for periods and regions.

I would like REGIONS to be on the bottom, and DATES on the left.

For the Amount I am using the following formula:

if date() = {?pFYStartDate} and Sum ({@fMonth01}, ) <> 0 then Sum ({@fMonth01}, ) else if date() = dateadd('m',1,{?pFYStartDate}) and Sum ({@fMonth02}, ) <> 0 then Sum ({@fMonth02}, )

else if date() = dateadd('m',2,{?pFYStartDate}) and Sum ({@fMonth03}, ) <> 0 then Sum ({@fMonth03}, ) ...... and so on for 12 months

On Change of:

Region

Date

Show Values:

Amount_formula

But this is not working for me.

Please help.

Thanks,

Tanya.

Tat