Excel Dashboard

[BobnFinn]

Hello Excel community,

I have a column header in excel as

Amount

CashDiscountAmount

CashDiscountDate

CreatedDate

InvoiceDate

DueDate

PostingDate

Vendor name

and I have the data for the respective column.

How do I calculate

Cash Discount utilized (Invoice trasferred before the cashdiscountdate)

Cash discount lost (Invoice trasferred after the cashdiscountdate )

paid late(Invoice posted after due date)

open invoices per vendor

After calculation i need to visualize data ...

Thanks  in advance

Bishnu

Helsinki

[#2]

@BobnFinn 

You've said After calculation i need to visualize data ...

To which I am going to respond as follows: your inquiry is forcing those of us who might want to help to need to visualize the spreadsheet you're looking at.

Which leads to this question for you: Is it possible for you to help us help you by posting either your actual spreadsheet, if it doesn't include any confidential or proprietary information, or a mockup that substitutes fictional names and data for the real?

Either way, you're far more likely to get a specific and helpful reply if you make it possible for us to actually work with your data or a representation of it. Please, an actual spreadsheet, not just an image.

[#3]

@mathetes 

Thanks , Problem Solved