Exclamation how to get correct balance use filter or pivot table ?

[hawas88]

Hi
how to get correct balance use filter and pivot table ?

\1
when filter to customer 1 need to get correct balance like highlight yellow
using simple filter
using pivot table
i want balance column sum only visible cell and result of previous up cell of balance .


test file
testt - en
thanks

[protonLeah]

(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)

• Click Advanced (next to quick post),
• Scroll down until you see "Manage Attachments",
• Click that then select "add files" (top right corner).
• Click "Select Files" find your file, click "open" click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Click "Done" at bottom right to close the Attachment Manager.
• Click "Submit Reply"

Note: Please do not attach password protected workbooks/worksheets
Ensure to disable any Workbook Open/Autorun macros before attaching!