1 of 1 people found this helpful
Go in Data - Connect to Data and select Tableau Data Extract.
This will allow you to do a secondary connection using the same extract.
Do you need to have the duplicate because of grand total customization, or could you perhaps use table calculations instead?
I need the grand total because on my sheet, I already have some filters in place which specifies a specific data set (For example, filters to a specific person, specific month, and item). I don't think using the table calculation could find me the overall in general.
Sweet, I didnt' know it could be use that way, Thanks Alex.
One question, what if in your example, say, you put Category: Technology in the filter, it would show that Alabama accounts for 3.09% of the total technology sale. Is it possible, on the same sheet, in the next column, show the % of total sale in the state (without the technology filter).