I have a Series of Orders (in a database) for a customer and I would like to create a calculation with sums the value for order based on a LINKED data source (spreadsheet)
The problem I have is I CANNOT create a FIXED LOD across 2 data sets.
Please see my sample data below
Date Account Type Account Num. Product id.
1/1/1999 Normal ABC1 Delux
2/1/1999 Normal ABC1 Delux
3/1/1999 Normal ABC2 Delux
4/1/1999 Normal ABC2 Standard
4/1/1999 Normal ABC1 Standard
Product ID Unit Price
When I create the relationship between Product ID.... and try and view the TOTAL revenue for the 'Normal' Category... it 'Sums' the Unit Price and THEN multiplies the by the orders
Is there a solution to MAP the unit price to the Order file IN tableau using a calculation or a particular type of join?
Can you create a left join
FROM Order file f
LEFT JOIN Pricing File p
ON f.productID = p.productID
If not, in Tableau you can Add connection, and drag and drop Pricing File, next to Order File, and select Left Join on ProductID
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...