4 Replies Latest reply on Jan 18, 2019 4:25 PM by Nicole Le Prohn

    Pie Chart, Dashboard, Filters,Highlighter

    SHAILESH Dixit

      Hi,

      I am using a pie chart. I have to create a dashboard with pie chart wherein it should have dynamic titles as

      ]1)total sales should be displayed,

      2)sales of selected region should be displayed(if two are selected sales for only those two regions)

      3) if two regions are selected then their combined sales %(((sales in 1 region+ sales in second region)/total sales in all 4 regions)*100) should be displayed.

      I have got the first two but not able to get the third one.

       

      Could anyboody help?

      Attached is the workbook.

       

      Thanks.