Multiple criteria on same report

[jeffs88keys]

I have a table called "Sales" which has fields Salesperson, Date_of_Sale, and Sales_Amount

For any given Salesperson, I would like this report to show the sales for the current year-to-date AND the prior year-to-date.

I'm completely comfortable with creating it if it were only for this year, but how do I get the field in place to reflect the prior year-to-date as well as make a subtraction between the 2 fields?

At a loss, and I appreciate the help.

 

 

[LunaLovegood]

Hi @jeffs88keys, You can check the functionality of criteria: https://howto.caspio.com/faq/reports-datapages/how-to-add-today-to-after-now-or-next-x-days-criteria/

[jeffs88keys]

16 hours ago, LunaLovegood said:

Hi @jeffs88keys, You can check the functionality of criteria: https://howto.caspio.com/faq/reports-datapages/how-to-add-today-to-after-now-or-next-x-days-criteria/

Thank you, however, I'm trying to run a report that basically has 2 forms of criteria.  This year to date AND last year to date.  I fully understand how to do one of them (your link), but not to produce the report with both sets of criteria.  Thanks

 

[AtayBalunbalunan]

UPDATE 

Documentation for adding criteria for a single field to use more than one comparison type: https://howto.caspio.com/datapages/reports/search-and-filter-comparison-types/

Jump to "Combining Comparisons and Range Searches" section.