1 Reply Latest reply on Jul 2, 2018 8:14 AM by Shinichiro Murakami

    Header Update - Swap Percent

    buildstar

      Hi Team,

       

       

      For the attached workbook and horizontal bar chart, I need to dynamically calculate top 20 / All percentages on the runtime and display in the header.

      The percentage will be based on the sales metric sum and needs to change dynamically based on the top 20.

       

       

      It has to be SUM(Sales) for first 20 manufactures as percentage of total sum. Similarly if the parameter selection is all the value needs to be sum(All sales) for the sales.

       

       

       

      Please advise