Comments
-
@ggenovese that seemed to be the case, I ended up just creating a view in analyzer joining one of the data sets back in to pull account name and that worked!
-
@ggenovese Sorry one more question, i appended the data and then tried to make a pivot table using the invoice number and summing those total columns, but as soon as I add in account name next to the invoice number it duplicates everything and wont put freight and sales in the same row and instead separates them into two…
-
Can't believe I never saw that before, thank you so much @ggenovese!
-
@ggenovese Thanks for your response, is it possible to keep the columns that don't match on the new dataset?
-
@DavidChurchman That worked perfectly, thank you so much!!
-
@marcel_luthi Sorry, they actually should all have values for each month, some would just be 0. @ST_-Superman-_ Honestly, I am not sure where to start with this one. I don't know how to calculate just the percent of change, I think I could figure out the rest from there!
-
@colemenwilson You rock, I was able to successfully make it. Thank you for your help!!
-
@colemenwilson That helps a lot, thank you! Do you know what that formula looks like? I am getting caught up on making a calculation for that. I am hoping I can add this as a column to a list view.
-
@MarkSnodgrass Good point, I will try resizing it and see if that works. Thank you for the video!
-
@Ashleigh Thank you, taking a look at that video! If I ever get this to work, I will post the results on here for everyone. :)
-
@GrantSmith Could you elaborate on how I can do that in an ETL?