-
1. Re: HELP - Pivoted data causing ISSUES - 2018.2
Ken Flerlage Jan 12, 2019 11:30 AM (in response to Richard Michaels)Yes, the pivoting is causing those numbers to be duplicated multiple times. You'll probably want to use a FIXED LOD (see FIXED Level of Detail Expressions - Tableau ) to correct this problem. Are you familiar with LODs? If not, please read the above.
For this to work, we'll need to better understand the data you're working with. Is there some sort of set of key fields to which the order amount ties. For example, I was looking for an order number or something like that? We need that key (could be multiple fields) so we can fix on that in the LOD.
-
2. Re: HELP - Pivoted data causing ISSUES - 2018.2
Ken Flerlage Jan 12, 2019 11:55 AM (in response to Ken Flerlage)Here's an example. If you were to tell me that each row can be uniquely identified by Sales Document and PLM Product ID (i.e. there is only ever 1 record in your original data set for each combination of these two fields), then we could create an LOD like this. We're telling it to fix on those two fields, then bringing back the max of the Euro Conversion.
Euro Total
// Use a fixed LOD to get the total, removing duplicate records.
{FIXED [Sales document],[PLM Product ID]: MAX([EURO Conversion])}
Then, when we sum this, Tableau will no longer sum up all the extra records--it'll only sum each unique pair of these once, which results in a total of 4,690,630.
This total doesn't match what you're expecting, so I'm going to assume that these two fields do not necessarily identify a unique line, but if you have a field or set of fields that do, you could just replace mine with those in the LOD. If you do not have a field that uniquely identifies each row, that will be a problem as we won't have anything to fix on. You may need to artificially create a row ID or something like that in your source.
-
3. Re: HELP - Pivoted data causing ISSUES - 2018.2
Richard Michaels Jan 13, 2019 8:19 PM (in response to Ken Flerlage)This is excellent, thanks!