Great Video on formatting with GT. A follow -up showing data manipulation from a raw data set would be very helpful. (I.e group and summarize, pivot wide, add rowwise and column wise subtotals and totals.) I often find myself doing the grouping and summarizing and pivoting steps in R and then exporting to excel to manually add all of the row and column subtotals and totals. Love to see how to do it all in R. For example, when creating an income statement, I can easily get to a pivoted wide view of the “input” lines ( I.e. the rows to be totaled), and then add the subtotals ( I.e total revenue, total cost of goods sold, gross margin, G&A, net income) manually in excel. Also a follow up with lubridate showing how to add year to date, fiscal year( Jan-Dec) , Trailing 12 Month totals ( and delta columns for the changes between these ) would be great
Great Video on formatting with GT. A follow -up showing data manipulation from a raw data set would be very helpful. (I.e group and summarize, pivot wide, add rowwise and column wise subtotals and totals.) I often find myself doing the grouping and summarizing and pivoting steps in R and then exporting to excel to manually add all of the row and column subtotals and totals. Love to see how to do it all in R. For example, when creating an income statement, I can easily get to a pivoted wide view of the “input” lines ( I.e. the rows to be totaled), and then add the subtotals ( I.e total revenue, total cost of goods sold, gross margin, G&A, net income) manually in excel. Also a follow up with lubridate showing how to add year to date, fiscal year( Jan-Dec) , Trailing 12 Month totals ( and delta columns for the changes between these ) would be great
Outstanding video, I find the GT package very intuitive and visually stunning. Thank you for sharing your knowledge.
Can u show how to get the highlighted columns as a sum of the others?
The data in excel was in millions, not billions! But if we still wanted it in billions, how would you add/remove decimal points to this table?
You are right. You can do the fmt_number() to adjust