how to display 2 expressions

[#1]

I want to display my attendance and non-attendance data in 1 bar graph per month.

This is the data:

Attendend or Not         July 2012      Aug 2012    Sept 2012Attendance                    1000              1500            2500non-attendance               200                 150                300
Now I am only able to display the attendance in 1 graph and the non attendance in another graph as the expression says error when I try to do SUM (attendance) SUM (non-attendance).
Can anyone assist with this? - Thanks

Attended   or Not	July	August	September
Non-Attendance	4960	5944	4347
Attendance	21759	27846	11711

[er_mohit]

hi

see the attached file

[#3]

Hi

use 2 expr

1st expr

if(

Attended

  or Not

='Attendance',sum(july)+sum(august)+sum(september),Null())

2nd exp

if(

Attended

  or Not

='Non-Attendance',sum(july)+sum(august)+sum(september),Null())

[#4]

Thanks, however I cannot open the file as I am using the personal edition. Please can you send me the expression

[#5]

Thanks, but it says "Bad expression"

[#6]

Hi

can u give ur expressions

im using some sample data its work

plz see that image

it display empno=1 sum in one bar and 2 in another bar same like ur

ateendend, not-attend

[#7]

I think it does not find Attendance and Non-Attendance

[#8]

Thanks, I have sorted it out.