• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

excel summary dashboard

ushaanu

Member
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
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 %)
 
Back
Top