-
1. Re: Total Sale Amount not shown in Data Preview pane
heather.vogt Jun 22, 2016 12:11 PM (in response to heather.vogt)And I should probably clarify that I know the Excel data isn't Tableau-friendly. I need to explain to students why, after turning on Data Interpreter, to "fix" the data, Total Sale Amount disappears or is reconfigured. Does Tableau just not like any total amounts it has not calculated itself?
-
2. Re: Total Sale Amount not shown in Data Preview pane
Kat Merriman Jun 22, 2016 12:23 PM (in response to heather.vogt)1 of 1 people found this helpfulI think Tableau is "fixing it" by ignoring everything above what it considers the headers. Since the headers are below the totals it's ignoring the totals. It seems like it's assuming that everything above Row 4 is just a header for the document and trying to clean it up.
I wonder if you removed the "percent of total sale" row between the totals and the rest of the data if it would still keep causing the issue?
-
3. Re: Total Sale Amount not shown in Data Preview pane
heather.vogt Jun 22, 2016 12:53 PM (in response to Kat Merriman)Kat,
I moved the data around, and it seems Tableau is picking it up now. Thanks!