how to get percentage on bars

[kunkumnaveen]

Hello All,

is it possible to show both value and percentage on each bar in bar chart..

dimension:category ,decision

expression i wrote :=count({$<Category={'Smelting'},MaterialName=,YEAR=,QUATERS=,name1=,ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}>}PRUEFLOS)

i am able to get value on each bar now i need percentage of each bar from total .As you see in screen short total is:50718, and this value is divided in to three diff bars    1)43512

                                                  6626

                                                    580

                                              50718

i tried by enable relative option but i get only percentage but i need both value and percentage ,

shall i write another expression for percentage and change chart to combo chart will it work?

thanks

naveen

[kaushiknsolanki]

PFA

Regards,

Kaushik Solanki

[kunkumnaveen]

in combo chart i use those diemensions and these expression

lots expression    =count({$<Category={'Smelting'},MaterialName=,YEAR=,QUATERS=,name1=,ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}>}PRUEFLOS)

percentage expression  =count({$<Category={'Smelting'},MaterialName=,YEAR=,QUATERS=,name1=,ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}>}PRUEFLOS)

please find attachment

[kaushiknsolanki]

Hi,

What you need to do is change the chart type back to Bar chart and then keep dimension as it is and then select the second expression and deselect the Bar option for that. And then you will have to change the expression to show both.

Refer to my above attachment.

Regards,

Kaushik Solanki