I didn't think about that.. I just assumed that if I changed my selection expert to a different time period then the formulas would calculate based upon the time frame rather than using a parameter?
I am trying to create a manual crosstab report, I am already grouping by vendor so I am trying to figure out how to write the formula to just pull out the sum of sales by each date of the month.
My problem is that I am not familiar with how to write the formula itself... do I use the Date...
How do I write a formula that would show total sales for only 1 day out of a particular month? I do not want to use the select expert because I want to have this same formula(or a variation of it) located in multiple places pulling different days on the same report?
I am not skilled with date...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.