Caleb Member

Comments

  • I think CASE function will solve this problem in Beast Mode. For Example if the row matched to certain category, you add the amount other wise return 0. Please look at following sample code. CASE WHEN col1 = 'xxx' THEN sum(col_amount) WHEN col1 = 'yyy' THEN sum(col_amount) END and you can use this to series. Hope this…
  • I currently have same issues. Has this problem been solved? If so, can you please advise me how to pull the data from SFTP sub folder? Thanks