I have 2 type of view for this report which is list and grid view. Currently i will let user to select the view and filters belong to the view. The only different for the filter for view is the 'date filtering'. List view filtered based on date range while grid view filtered based on month/year. In list view, result will be displayed in more details, while grid view will only show the price changes based on date. I will display 1st to 31th based on month selected by the user on column grid view and display relevant item purchased price changes on the column.
Is my logic correct or any better suggestion on doing this? Thanks.
Just in case you do not have a visual representation of your current logic yet, I found this which seems to match your description perfectly: http://webnus.biz/plugins/modern-events-calendar/full-calendar/
Only here it is about events, while you have products.
I think this is a nice design.
Please or to participate in this conversation.