I'm creating a chart that sums the spend per vendor.
Next I'm applying a set pareto action. This way I can drill down to show the largest contributors to the overall spend.
A tekst box is displaying the percentage of contribution.
This works great for the whole data set.
So to get the percentage I'm using the sum(spend) / sum(total spend) (the real equation is a bit more than that but this is for demo purposes).
The spend encompasses many years. So a user might want to select a specific year. Now I'm in trouble as the TOTAL part of the equation is not taking into account my selection.
So how do I combine the selection with the total. Meaning the total spend of the selected year versus teh pareto action that takes a percentage of the sum(spend)
