I was alerted by an old request in Tableau forum dated year 2012.

https://community.tableau.com/ideas/1364

Today I found a solution for it. It needs 5 calculated fields, plus conditional formatting. The solution is based on custom total and subtotals method pioneered by Zen Master Jonathan Drummey.

We will use the Superstore data as an example, excluding a few subcategories to emulate a single subcategory in a category.

Here are the steps:

1. Union the data set with itself in the data source editor

This will add a new dimension Table Name to the data source.

2.Create 5 calculated fields

- Subcategory New

This adds 'Total' as a Subcategory.

- Sales New

This will show the equivalent calculation of Grand Total using custom grand total technique.
3

In Tableau text fields, such as text label or tooltips, there is no text wrap option. When a text label is long, we wish we can have it. Here we are going to show that we can make it happen.

In one project, we have limited space for text labels. That means, we have limits on both width and height. Given that the text label string can be very long, we need to wrap the text around. Since there is no such functionality in Tableau, we have to solve the problem by ourselves.
9

Recently, for the first time I had to connect to an Excel file on a SharePoint site. I was told that by opening Tableau's new data source interface and selecting Excel, I just need to add the URL to the file, such as http://server/site/library/filename.xlsx

It did work at first! We get all the data etc. Then strange thing happened. The data source won't update by refreshing data source, even when we made changes in the Excel table.

In the previous post, we showed how to create bar chart multiples in a single sheet with the same measure. Here we are going to show you how to do this for different measures. Using the Superstore data set, we are going to show bar chart multiples for Sales, Profit and Profit Ratio per Subcategory. It gives a simple summary of leaders and laggards on important measures. The key is to visualize them all in a single sheet à la Tableau Prep.
Loading
Dynamic Views theme. Powered by Blogger. Report Abuse.