Actually, it's quite difficult technically to achieve what you want (Not impossible)
Looks like easy simple chart from a glance, but back ground calc and table setting is following complexity.
previous_value("")+(if first()=0 or lookup(min([Topping]),-1)=lookup(min([Topping]),0) then str(lookup(min([Person]),0))+", " else "" end)
[Number of records 2]
window_sum(sum([Number of Records]))
Similar setting for person side.
This is much much easier approach without any calculation / table calculations.
Sample Data_SM_10.1.twbx 29.1 KB
This is awesome, Shin. Thank you!
You can use table calculations to build a list of relevant names. Sample solution workbook attached (version 10.1.4).
Here's what I did:
First, restructure your view…
1. Bring [Person] onto the Columns shelf, to the left of SUM(Number of Records).
2. Change SUM(Number of Records) to be a Running Total over Table (Across).
3. Create a calculated field [Last column] to use as a filter. Configure it to compute along [Person].
4. Add [Last column] to the filters shelf, and filter on True.
5. At this point, your view should identical to how it originally did. But now it is constructed in a way that will allow us to leverage table calculations to compile the list of names for each row.
Now for the magic…
6. Create a calculated field [Append Names], which will use PREVIOUS_VALUE to compile the list of names, one at a time, from the columns in the view. Configure this field to compute along [Person].
7. Add [Append Names] to the Marks shelf as a Tooltip element, and update your tooltip text to use it.
Sample Data_JC-10.1.4.twbx 23.9 KB
Ah, Shin beat me to it. Well done, Shin.
No worries, it's interesting to see how you both solved it! Great minds think alike Thanks!
That sometimes happens