Forum Discussion
Helper IFilter a slicer with the date range
Apologies for the delayed response, simple solution i used a duplicate table the drop safe data as my main table that shows all bag numbers and removed all duplicate bag numbers from it, i also kept the date column in and removed the rest of the columns from the table so it only had date and bag number, i than added those bag numbers to my chiclet slicer for selection and used a relative date filter to show bags for the last 7 days only
Hi TaariqHussain ,
What's your expected result? Do you want to get the difference between sum of drop safe data and point of sale data? Besides that, you also want to get the difference between sum of drop safe data and bank account? Am I right? Could you please explain more about your expected result based on the shared sample data? It would be helpful to find the solution. Thank you.
By the way, you also created a calendar table. And created the relationship with the above 3 tables. Could you please describe the backend scenario for these date fields? Thank you.
Best Regards
Helper IApologies for the delayed response, simple solution i used a duplicate table the drop safe data as my main table that shows all bag numbers and removed all duplicate bag numbers from it, i also kept the date column in and removed the rest of the columns from the table so it only had date and bag number, i than added those bag numbers to my chiclet slicer for selection and used a relative date filter to show bags for the last 7 days only