Something like this?
Please find the attached wb (version 9.2).
It is done with Tableau Pivot & Split.
Hope it could help with a hierarchy.
What could be counted is a matter of another topic.
Topic_Tree_YF.twbx 41.1 KB
Hi Yuriy - thank you for your reply.
Interesting approach and it looks like the correct thing to do, except I would prefer to have the Topic name displayed instead of the numbers.
However, this still entails some editing in excel beforehand - I am wondering if there is a way to do this without any prior editing and do it straight in Tableau?
There is only one single name for every Topic
in your Topic Dummy Data.xlsx ("Topic" :-).
So if you would like to add it to a view, please do.
If you would like to see how your actual Topic names work,
please share a sample -- I am glad to help.
BTW, all the manipulations are done
inside Tableau -- no Excel munging required.
Ah! I forgot about the pivot function in Tableau!
The Data is as you see just a dummy and I was trying to avoid making up names for each topic I see what you have done and I think I can change it so it shows the full name, so "Topic + number".
So thank you very much for you effort and help!
Eleonor, you're welcome.