paulette33
Technical User
I have a report that pulls that has a condition for one year. I then filter the report to only display the current week. I have a YTD calculation for revenue, which uses the following formula - nofilter(sum(revenue)). This returns the current YTD revenue as there is only revenue data up through the current week. I need to also calculate the YTD plan revenue. I can't use the same formula since the plan data is populated for the entire year and I only want to sum the plan from the beginning of the year through the current reporting week. Any ideas on how this can be done without using a different data provider?
Thanks in advance!
Thanks in advance!