Forum Discussion

Taariqmega's avatar
Taariqmega
New Member
2 years ago

Data filtering in a date range

Good day

 

I need help filtering the following data.

 

I have 3 sets of data in which i track for differences as per below.

 

We have cashiers that drop money from their tills into the drop safe, the cashiers drop the physical cash into the drop safe which counts the cash and puts it into a bag which is in the safe, and than prints a slip with the bag number and the amount of cash dropped in,  the cashier than takes the slip and inputs the details of the drop onto our point of sales system: Bag number and amount dropped. there are multiple drops into the single bag until its full, the money than gets deposited into our bank account when picked up and the reference in our bank account is the bag number as well. so the point of reference i use to track the money dropped is the bag numbers,

 

I have 3 sets of data which has the same data: which is bag numbers date dropped and amounts

the 3 data sets is the Drop safe data, our point of sales data, as well as bank account the bank account us different as it shows the total amount received for the full bag which essentially should agree to the sum of all the drops.

 

Now my visual i use measures to track the data is the sum of all the drops from the drop safe portal less the sum of all the drops tracked on our point of sales system which should net off to 0 if all was captured correctly.

 

and the next one is the sum off all the drops on the drop safe portal less the amount received in the bank account which should net off to 0( this is to make sure that the drop safe provided paid us correctly)

 

 i set a relationship between the 3 tables using the bag number and all 3 dates columns to a calendar,

 

Please advise on how i can get it to work in the following way:

 

If i set the date filter for lets say relative date to the current week, i want a separate filter( I want to use a chiclet slicer) to show the bag numbers applicable to the current week only where i am able to click on the bag number and it filters the visual based on that bag only

 

I will post set of sample data below

1 Reply

  • Apologies for some reason my sample data is being marked as spam and dissappearing, please see pic below