Excel Dashboard

%3CLINGO-SUB%20id%3D%22lingo-sub-2009047%22%20slang%3D%22en-US%22%3EExcel%20Dashboard%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2009047%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Excel%20community%2C%3C%2FP%3E%3CP%3EI%20have%20a%20column%20header%20in%20excel%20as%3C%2FP%3E%3CP%3EAmount%3C%2FP%3E%3CP%3ECashDiscountAmount%3C%2FP%3E%3CP%3ECashDiscountDate%3C%2FP%3E%3CP%3ECreatedDate%3C%2FP%3E%3CP%3EInvoiceDate%3C%2FP%3E%3CP%3EDueDate%3C%2FP%3E%3CP%3EPostingDate%3C%2FP%3E%3CP%3EVendor%20name%3C%2FP%3E%3CP%3Eand%20I%20have%20the%20data%20for%20the%20respective%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20I%20calculate%3C%2FP%3E%3CP%3ECash%20Discount%20utilized%20(Invoice%20trasferred%20before%20the%20cashdiscountdate)%3C%2FP%3E%3CP%3ECash%20discount%20lost%20(Invoice%20trasferred%20after%20the%20cashdiscountdate%20)%3C%2FP%3E%3CP%3Epaid%20late(Invoice%20posted%20after%20due%20date)%3C%2FP%3E%3CP%3Eopen%20invoices%20per%20vendor%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAfter%20calculation%20i%20need%20to%20visualize%20data%20...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%26nbsp%3B%20in%20advance%3C%2FP%3E%3CP%3EBishnu%3C%2FP%3E%3CP%3EHelsinki%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2009047%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2009798%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Dashboard%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2009798%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F909284%22%20target%3D%22_blank%22%3E%40BobnFinn%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou've%20said%20%3CEM%3EAfter%20calculation%20i%20need%20to%20visualize%20data%20...%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20which%20I%20am%20going%20to%20respond%20as%20follows%3A%20%3CU%3Eyour%20inquiry%20is%20forcing%20those%20of%20us%20who%20might%20want%20to%20help%20to%20need%20to%20visualize%20the%20spreadsheet%20you're%20looking%20at.%3C%2FU%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhich%20leads%20to%20this%20question%20for%20you%3A%20%3CU%3EIs%20it%20possible%20for%20you%20to%20help%20us%20help%20you%20by%20posting%20%3CEM%3E%3CSTRONG%3Eeither%3C%2FSTRONG%3E%3C%2FEM%3E%20your%20actual%20spreadsheet%2C%20if%20it%20doesn't%20include%20any%20confidential%20or%20proprietary%20information%2C%20%3CEM%3E%3CSTRONG%3Eor%3C%2FSTRONG%3E%3C%2FEM%3E%20a%20mockup%20that%20substitutes%20fictional%20names%20and%20data%20for%20the%20real%3F%3C%2FU%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEither%20way%2C%20you're%20far%20more%20likely%20to%20get%20a%20specific%20and%20helpful%20reply%20if%20you%20make%20it%20possible%20for%20us%20to%20actually%20work%20with%20your%20data%20or%20a%20representation%20of%20it.%20Please%2C%20an%20actual%20spreadsheet%2C%20not%20just%20an%20image.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 Replies

@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.

@mathetes 

 

 

Thanks , Problem Solved