Expenses and Sales- Filter problem

[fundi]

[FONT=&quot]Hello guys,

Please find attached an EXCEL I created for Daily Expenses / Outputs and Daily Sales/Inputs. (cant find attachment feature here)

Unfortunately I can't use the FILTER properly.

-If you try to filter BANK category to show only, it also includes Cash.[/FONT]

[FONT=&quot]-If you filter CASH category to show only, it also include the BANK.

So basically, I am not getting the END BALANCE figure
Where am I wrong ?[/FONT]

 

[sandy666]

(cant find attachment feature here)

post a link here to the shared file from OneDrive, GoogleDrive or any similar

 

[fundi]

Here is the excel file
https://mega.nz/#!yNM1XA7T!HC2kOrwlFzUm4l1MU7bEnuMvtN5acJ26l0M3VBDW6IA

 

[fundi]

No help yet