Sorting share of paid and unpaid invoices for each company

%3CLINGO-SUB%20id%3D%22lingo-sub-2159039%22%20slang%3D%22en-US%22%3ESorting%20share%20of%20paid%20and%20unpaid%20invoices%20for%20each%20company%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2159039%22%20slang%3D%22en-US%22%3E%3CP%3EHello.%26nbsp%3B%20I%20have%20two%20more%20tasks%20to%20do%2C%20could%20you%20help%20me%2C%20please%3F%3C%2FP%3E%3CP%3E1)%20So%20first%20one%20is%2C%20I%20need%20to%20calculate%20the%20part%20of%20invoices%20paid%20in%20time%20and%20invoices%20not%20paid%20in%20time%20for%20each%20company.%3C%2FP%3E%3CP%3E2)%20And%20the%20second%20task%20is%20I%20need%20to%20calculate%20part%20of%20the%20invoices%20paid%20in%20time%20and%20invoices%20not%20paid%20in%20time%20in%20each%20month.%20%2Bdiagram%20and%20the%20starting%20point%20is%20B%20collumn%20dates.%20If%20that%20makes%20sense.%20I%20would%20really%20appreciate%20your%20help%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2159039%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2159124%22%20slang%3D%22en-US%22%3ERe%3A%20Sorting%20share%20of%20paid%20and%20unpaid%20invoices%20for%20each%20company%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2159124%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F975852%22%20target%3D%22_blank%22%3E%40linards2000%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20added%20two%20pivot%20tables.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello.  I have two more tasks to do, could you help me, please?

1) So first one is, I need to calculate the part of invoices paid in time and invoices not paid in time for each company.

2) And the second task is I need to calculate part of the invoices paid in time and invoices not paid in time in each month. +diagram and the starting point is B collumn dates. If that makes sense. I would really appreciate your help  

2 Replies

@linards2000 

 

I added two pivot tables.

Cheers! Thanks for the help. @Hans Vogelaar