Need help for Bar chart

[#1]

Dear All,

Below is my requirement

Month is Dimension

RM & PM are two values of field Catergory

I need Total of RM & PM as well

Month	PM	RM	Total
Apr-11	177	144	321
Apr-12	149	76	225
May-11	182	130	312
May-12	195	59	254

& I have to show it as follows

Please reply as soon as possible..its urgent

Thanks

[sreenivas]

Hi

PFA file and click on the FASTCHANGE for Barchart and Table option

[#3]

Hi sreenivas,

Thanks for quick reply.

RM & PM are not 2 seperate fields,instead they are values of field category.

So how can it be achieve in this case?

& one more thing...month values will be coming dynamic..like current year current month selection gives me

these four monthname values

ie Current Year Current Month

    Current Year Last Month

     Last Year Current Month

     Last Year Last Month

Based on these four I want to show RM & PM (which are field values of field Category) as well as Total values

[sreenivas]

In Expression1;-Sum({<Category={'RM'}>} valuefieldname)

Expression2;-Sum({<Category={'PM'}>} valuefieldname)

Expression3=column(1)+column(2)

[sreenivas]

Can u add the script for that file

[#6]

Hi sreenivas,

current year current month selection gives me

these four monthname values

ie Current Year Current Month

    Current Year Last Month

     Last Year Current Month

     Last Year Last Month

what about this??

Thanks.

[#7]

Not possible..since developement is done on client machine..& dont have permission to take the data

[sreenivas]

Specify the date format of that datefield

[#9]

Date format will be DD/MM/YYYY

Month will be Monthname(MM-YYYY)

[sreenivas · Accepted solution]

Expression1:-- Sum({$<Category={'RM'}, Month={$(=Max(Month)),$(=Max(Month)-1)}, Year={$(=Max(Year)),$(=Max(Year)-1)}>}Value)

Expression2:-- Sum({$<Category={'PM'}, Month={$(=Max(Month)),$(=Max(Month)-1)}, Year={$(=Max(Year)),$(=Max(Year)-1)}>}Value)

Expression3:-Column(1)+Column(2)

Dimension-Month Year