2 Replies Latest reply on May 31, 2012 7:34 PM by gavin.bowler

    Using data across multiple worksheets / dashboards

      I am looking for information re: how to use data across multiple worksheets / dashboards.

       

      At the moment I have a worksheet with a list of products, what I would like to do is find the top N products sales as a percentage of all sales, and then use this to control the shape of a KPI indicator that will be on my main dashboard.

       

      I am not sure how to do this, if anyone can help me out I would really appreciate it!