8 Replies Latest reply on Dec 19, 2016 10:23 AM by Vishal Bhatia

    Need a help to create Pie Chart using measure

    Vishal Bhatia

      Hi,

      I am trying to create a Pie chart without dimension (as not able to create field as dimension due to run time calculation) but unable to do so.

      If you look at attached sheet, For "Data" tab I am able to populate the Pie chart but not for sheet4 as I am calculating Site wise count of Subject at run time and with this calculation I am getting my fields as measure not dimension. I need to showcase pie chart count in red and green where these values can be anything from parameter.

       

      Country site Count  KPI (If Count>5 Then 'Red' Else 'Green')

      ========================================================

      US            1       5         Green

      US            2       9         Red

      UK            3       4         Green

       

      I have attached the workbook also for reference.