Please look at the attached workbook and see if it is what you are looking for. I took what I feel is the easiest approach of making a couple of different visualizations and combining them on a dashboard. The key to my approach was the use of a parameter (because you know what the total is, so this will let you enter the value) and a calculated field to come up with the difference. I also used a global filter for person to answer the second part of your question.
There are other ways to solve this problem. One approach would be to customize the grand total with a calculation to show you "others". That would be a more complicated solution, but if you're interested or have any other questions as you look at this, please let me know.
Person Points.twbx.zip 16.8 KB
Thank you for your answer – on the first step it was very helpful.
But is there also a way to create the „ohter persons“ as a new characteristic of the dimension « person » (not as a new dimension), so that I am able to select:
dimension „person“ (with their points) :
person a has 30 points
person b has 20 Points
person c has 10 Points
person d has 5 Points
other persons (100-sum of persons) – in this way it would be 35 points
Maybe this sounds a little bit complicated to create, isn’t it ?
I'll have to give it some thought, but I don't think it would be possible in this case, without adding some data at the source. What is your data source? (is it the Excel document you originally posted?) Would it be possible to add a row that was "Other Persons"? Or maybe, your connection could be changed to a custom SQL that unioned in another "Other Persons" row.
If you happen to have a packaged workbook and a little more detail on your actual data source, I'd be happy to take a look!