2 Replies Latest reply on Sep 25, 2016 2:06 AM by Oli Darley

    Fixed? Include?

    Oli Darley

      Hi

      If I need to show the top 20 companies (out of 100 companies) by sum of sales and would then like to add a table calc to show percent of whole, or running sum, how do I ensure that the percentages sum to 100% of all 100 companies, NOT 100% of the 20 companies in the view (without hard coding the total which was my temporary fix)?

      Is it a Fixed or Include function I need?

      Thanks

      Oli