Percentage and Value in a 2 Dim Chart

[orital81]

Hi, I have a 2 Dim Bar Chart (MO# and Reason Code) where I would like to show % and Value.

The % should be Sum(Hours) aggregated by MO# and Reason Code devided by Sum(Hours) Aggregated by MO#

I am using the expression  

Sum(Hours)/Aggr(Sum(Hours),MO#) But it seem to work only in certain cases

Please advice:

Which calculation should I use

How can I show both % and Value in the same Chart (I tried to set Righ and Left in the axes, didn't word) i

Attached the QVW

Thanks in advance

[kaushiknsolanki · Accepted solution]

Hi,

     Try =Sum(Hours)/sum(TOTAL<MO#> Hours)

     But in a bar chart 2 dimension and 2 expression will not work.

     You must remove one dimension or one Expression.

Regards,

Kaushik Solanki

[orital81]

Great! Thanks a lot Kaushik