Thank you very much, Norbert!
I learn that you created calculated fields for each item in the dimension variables City and Region.
I wonder if there is a more efficient way to do this without creating calculated fields.
I also would like to ask, if you don't mind, how to extract the table created in Tableau into Excel in the same layout (8 columns and 5 rows in your example file), i.e. without exporting the data embedded in the current table as a flattened csv file with only two columns.
Thank you, again!
Within "my sight" I only can of "calculated fields".
Concerning your last remark I think you are refering to "Data-Intepreter" and the "pivot-functionality" within tableau
To answer your question about "how to extract the table created in Tableau into Excel in the same layout..."?
The easiest way to accomplish this is -- select all marks, then use CTRL+C to copy the data, go to Excel and use CTRL+V and you will get a data set (summarized to the level of detail in your worksheet) that mimics the layout of your view. NOTE: This is VERY different from using the Export option -- test both out and see the difference.
In terms of your original question, it would be ideal if you could post a packaged workbook with sample data, as well as your expected output, as a lot of the possibilities in Tableau depend entirely on how your data is structured.
Happy to help if you can post a sample TWBX using one of the sample datasets that ships with Tableau -- best of luck!
The copy and paste functionality is discussed at the links below, if you need clarification -- you can also copy and paste data INTO Tableau as a Clipboard data source (a text file).
Thank you very much, Norbert and Matt!
It seems the copy-paste method only works for Tableau Desktop, not for Tableau Public... What a pity...!
What I want to do is to copy the table in the example Tableau file attached and shown below to Excel in the same layout (see image 2) below.
Table in Tableau:
I want to get a table in Excel in the same layout as shown below:
However, following the suggestion of copy-and-paste, what I got in Excel is a table shown below which is not in the same layout as it is in Tableau.
Table in Excel that is copied and pasted from Tableau:
I assume I missed something important here, and I appreciate if you can kindly advise!
Thank you both very much!
As to my question about creating table for three categoriecal variables, here is an example file that I'm not able to produce the results I want.
What I want is to create a table shown below:
However, I can only get a table for two of the three categorical variables in Tableau:
Appreciate your kind advice, greatly!