2 Replies Latest reply: May 4, 2015 6:48 AM by beck bakytbek RSS

    How to display dimension value along with an expression in pie-chart

    Bimala Mishra

      Dear experts:


      Can anyone help me in guiding how to display Dimension Value along with an expression in pie-chart.


      I am using the below expression



      =Dual( $(=GetCurrentField([Factory Country])) & ' (' &num(sum( [Avg. Tot Capacity Per Week]),'#,##0')& ')',num(sum( [Avg. Tot Capacity Per Week]),'#,##0'))


      Where ([Factory Country])) is the dimension


      I have used similar kind of expression in other qvw, which worked fine, however it does not work here. It throws out an expression saying  "No Data to Display", however there is data.


      Kind Regards,