Thank you for response. But the link doesn't work. Can you provide a link that can work?
Jonathan Drummey -- Links to "The Next N Table Calcs" just come up blank now!! I have calc 15 bookmarked for threads like this one. But even googling to Next N and selecting anything that comes up will go to the page, but the page has nothing on it. (At least for me on IE.)
Minc650 -- Your calc will look something like this:
IF INDEX() = 1 then ATTR([Dimension Name])
PREVIOUS_VALUE(" ") + ", " + ATTR([Dimension Name])
This will build a growing string of comma-separated values as it walks along the dimension list that is on your sheet. The last one in the list will be the full list.
In the attached (V 10.5) I made an example in Superstore building a list of all the states.
On the sheet is the growing list as it gets built state-by-state. In the title is the final list.
For kicks, put state on filters. Start it off with all the states selected. Then take out a state or two and you'll see how the values change for you.
Superstore -- Build the list.twbx 382.1 KB
1 of 1 people found this helpful
Hm, the original page is still there:
But for some reason the workbook isn’t properly displaying on Tableau Public;
When I log in to Public I can get to the workbook from my profile but if I copy & paste out a link to any of the views I get the same results…looks like something for support.
In any case I’ve attached the workbook.
Thank you so much. I tired a bit to follow your method in my workbook. Basically I could get the correct number of items I need, but still a bit problem there. I'll carefully study this and do some modification.
CM -- I'll be glad to answer any question or provide guidance if you get stuck with this.
Once you have the technique down, it's a piece of cake, but owning the technique the first time can be a struggle.
The key here is the PREVIOUS_VALUE() function. It's the only recursive function in tableau that I'm aware of. It essentially says, "look at the previous value of this calc in the table..." (and then set the value of this calc for the current position in the table.)