There is a table calculation that will compare columns of data - you can look at absolute difference or % difference
Tableau is a database focused system where excel is cell based - in Tableau you would work with dimensions and compare the value of elements in the dimension on a day to day basis
I.E drag DATE to the columns and the dimension to row like Product ID in your excel sheet - then drag Unit cost to the VIS - it will come up with sum as the aggregation - Right click the pill for Unit Cost and select Add Table Calculation - then difference across rows
Let me know if this helped
Thank you for your quick reply.
I've been able to do what you suggest with measures.
How do I handle strings? I can drop them on the text mark and display them, but I am trying to show differences.
I've had some success using string functions, but the only way I have seen to do it is to create a calculated field for each column, and I don't want to do this if I don't have to considering the number of columns I have.
Let me clarify my end goal.
I want to show, by report date and Product ID, if that Product ID has had any changes, to any field, since yesterday (or some other time period). This will be an action list for people in my group (e.g., "oh, product id 2257U had the date pushed out and cost change. Let me go find out why.")
Hi Chris -
I don't know of a way to make that happen - what will happen is similar to what is shown below
you would have to put each dimension on the vis and then create it again as a measure and place both on the vis as attributes - but I don't know a way to do the comparison except visually
Maybe someone else knows a way