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.

  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


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

Presentation on basis of Pivot table

Discussion in 'Ask an Excel Question' started by Veeru106, May 16, 2018.

  1. Veeru106

    Veeru106 Member


    I am creating a dashboard on the basis of Pivot table i have.I m facing one issue here.

    I am linking my values on the basis of Pivot table (File attached)

    In Present sheet i am assinging col. A , Row 2 and Row 3 values .

    Issue is...these values work only if these are in Pivot table all the time.

    Like In Col. A i am selecting 2016-Actuals,2017, 2018 actuals and Q4 ROFO.

    Now col. A is not taking Q4 ROFO from pivot because we have no data in Q4 ROFO for the month of Jan but have in Feb.
    and because of this My Row 3 values are also disstrubed.

    Can anyone please suggest method to correct it.
    Thanks in advance

    Attached Files:

Share This Page