Need help, please! :)
I have a report with a prompt to select year and a prompt to select month. The query is filtered based on the selected year and I can get those numbers in the report. However, I also want to add another column to the report with data only for the selected month. The desired result is to see both, values only for the selected month and values only for the selected year in the columns next to each other. In the rows, I have products. I can't get the month portion of it. I've tried to use the filter expression, but was unsuccessful. Please help :)
CREATE TWO LISTS AND FILTER THEM INDIVIDUALLY....BUT PLACE THE TWO LISTS INSIDE ANOTER LIST AND CREATE MASTER DETAIL RELATIONSHIP SO THAT..THE DESIRED RESULT WILL BE FOR THE PRODUCT ON A SINGLE ROW.
TRY THIS.