U ushaanu Member Mar 31, 2015 #1 Hi all, I need on summary dashboard for enclosed data , actually I have some data with me like . Aging count Profit I need month on month summary data but in this summary needed comparison with last month. exp file enclosed. Thanks Anu Attachments expm1.xlsx 10.3 KB · Views: 2
Hi all, I need on summary dashboard for enclosed data , actually I have some data with me like . Aging count Profit I need month on month summary data but in this summary needed comparison with last month. exp file enclosed. Thanks Anu
Asheesh Excel Ninja Mar 31, 2015 #2 Just a quick clarification - Count Shift calculation would be This month count - last month count Profit shift calculation would be (This Month Profit% - Last Month Profit%)/Last Month Profit %)
Just a quick clarification - Count Shift calculation would be This month count - last month count Profit shift calculation would be (This Month Profit% - Last Month Profit%)/Last Month Profit %)
Asheesh Excel Ninja Mar 31, 2015 #4 In that case..see the attached Attachments expm1_Anu.xlsx 12.6 KB · Views: 3
Asheesh Excel Ninja Mar 31, 2015 #5 Some changes use this one... Attachments expm1_Anu.xlsx 12.9 KB · Views: 8
U ushaanu Member Mar 31, 2015 #6 Asheesh said: In that case..see the attached Click to expand... Thanks Asheesh working perfectly fine.
Asheesh said: In that case..see the attached Click to expand... Thanks Asheesh working perfectly fine.
U ushaanu Member Apr 1, 2015 #7 Asheesh said: Some changes use this one... Click to expand... hi asheesh, I need small changes req like count shift (Feb-jan) if count in feb is 57 and in jan 43 then shift is 14 . thanks anu
Asheesh said: Some changes use this one... Click to expand... hi asheesh, I need small changes req like count shift (Feb-jan) if count in feb is 57 and in jan 43 then shift is 14 . thanks anu