Forum Discussion

Andrés Ferrer Ortín's avatar
Andrés Ferrer Ortín
Copper Contributor
May 30, 2018

TimeLine in a PivotTable from another PivotTable

Hi,

 

  • I have a table with diferent information with a column date.
  • I have create a PivotTable A from the table where a row is the date column and values are other columns. In this PivotTable A I can create a TimeLine with the date field
  • I have create a PivotTable B with the source is the PivotTable A.  And I can't create a TimeLine because excel not recognize the column date how a date.

Some idea?

 

Thank you.

excel
  • Andrés Ferrer Ortín's avatar
    Andrés Ferrer Ortín
    Copper Contributor
    May 30, 2018
    Hi I find the problem. The origen table have dates = blank, then excel dont use this column how a TimeLine. My problem now is how to do excel to convert BLANK to DATE. Thank you