Hi,
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
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