1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. 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...

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

Day Remaining Dashboard Tracker

Discussion in 'Discuss Data Visualizations and Charting' started by dieselkhan, Nov 12, 2017.

  1. dieselkhan

    dieselkhan Member

    Messages:
    247
    There isw spreadsheet and i need to data analyst and make good dashboard

    need how many Days remaining by Supplier and sales Type.

    and also how many days remaining by Name as well ... so we can track how many days lift to become zero...

    Please help me out

    Attached Files:

  2. Hui

    Hui Excel Ninja Staff Member

    Messages:
    10,772
    H2: =INT(Table1[@EndDate]-Table1[@[1st SumbitSale]])

    Then apply filters as required

    If you want Totals have a look at the Aggregate() function
    Sum =Aggregate(9,5,Range)
    Count = Aggregate(2,5,Range)

    Or take all the data into a Pivot table that will sumarise the data as you require
    Thomas Kuriakose likes this.

Share This Page