hi people! so i posted a question previously and it probably had too many questions. see if i can break it down into many parts.
so in the Excel file, i have 3 tables. 1 is the revenue for F2F. 2 is the revenue for Online. 3 is the Date table.
how do i get the chart to show ALL years and YTD revenue for F2F (2015 to 2019), but just latest YTD for Online (2019)?
my F2F Revenue would be:Revenue YTD = TOTALYTD(SUM(MainTb[Revenue]),DateTb[Date])
Bookmarks