Thank you so much. Really appreciate your help!
Hi, Thanks for taking a stab at this. It's almost right, however in your calculation above you did the sum of all bill rates. Instead you should ha...
Thank you! That helps. I was trying to filter the data that is brought in directly in the source step, to help with loading time. But seems like that ...
Hi, Thank you for the suggestions. Catalin's syntax suggestion seems to work, but i am getting the error message: Formula.Firewall: Query 'COGS ...
Thank you so much for the quick response. Can the ODC Workbook Connection be saved in a Sharepoint shared folder? The workbooks that I want to use the...
Hi Catalin, Thank you for clarifying that aspect of list versus text. I updated the filter to CurMoName{0} and it worked. Very helpful hint. Apprec...
The attachment might not have saved in my post. Here it is.
Thank you so much! Ah, demoting the headers. I did not know I can do that and that solves a big problem for me for other queries as well. Awesome tips...
You are right! First time submitting attachments here on the forum and missed that step 🙂 Thank you.
Hi Riny, Please see attached file. The tab All Time monthly revenue tracks sales for every month. Every month we add a new column for the reve...