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!
Hi Gavin,
See the attached for an implementation of both techniques (top N and KPI) using the superstore sales sample data. Both techniques use table calculations, for the top N we use the INDEX() calculation and for generating the KPI we get the Percent of Total using the basic Quick Table Calculation, with some customization.
Let me know if you have any questions,
Jonathan
