add two dimension and expression in one graph

[#1]

Hi ,

I want to create graph where in i want to show two dimensions and expressions.

Employee not completing 8 Hrs and Dept not completing 8 hrs with percentage.

Dept whose 8 hrs percentage will less than 20%, Must be in Red same way more than 20% will be in Yellow. and more than 50% in Green.

Can i show it is same graph.

Please suggest.

I have attached the data.

DEPT_NO      DEPT_NAME

1                    Chairman

101                HR

102                IT

103                Inspector

120                Finance

121                Quality

Thanks and Regards,

[thomaslg_wq]

Hi,

you can also add this inline load :

LOAD * INLINE [

    dimension

    Departement

    Employe

];

And then in you chart, you can use these two separated dimensions :

[#3]

Hi

finally i have got the correct percentage to display on pivot table.

Please assist me how to display the same on graph where employees percentage is less than or equal to 20

should be display in RED and above 20% Yellow and 40% green in guage graph or any other graph with employees/

Thanks