see the attached - I used super store data since it is readily available -
Start making a text chart with the following calculated fields
% of total = sum([Sales])/WINDOW_SUM(SUM([Sales]))
and a running % of total = RUNNING_SUM(sum([Sales])/WINDOW_SUM(SUM([Sales])))
Place them on the chart like shown below
Now you can copy and drag the values you don't want off the viz and then plot - see below for the individual % of total
and these for the running total
Let me know if this helped
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
% of total example.twbx 1.2 MB
Thank you so much for your quick response. Unfortunately am looking for a solution without using table calculations. In your graph the months nov 2016... etc are still part of the chart, i desire a solution where i can present a summary output without details in the final graphic /table
Your post about Pareto chart works for me where I am creating a calculation using measure value from two data sources ( data blending).
thank you so much!!
<3 <3 <3 <3