07-11-2025 10:21 AM
I am looking to run a monthly report for all sales data. I am able to achieve this now using the new Product Mix report by selecting my desired date range (ie 6/1-6/30 for the month of June). Am I able to pull in date as a column? I am hoping to be able to filter my report data by date, in order to see which dates have xyz sales. Does anyone have a solution for this, currently I am pulling down a Product Mix report daily in order to manually add the date.
07-21-2025 04:46 PM
Thanks for reaching out to the community! The way you are currently pulling this data is the best approach. Currently, the Product Mix (PMIX) report does not allow you to pull in the date as a column directly within the report.