Can anyone tell me how I can put an IF conditional statement into an Excel 2007 pivot table.
=if(or('Project Status' = "Funnel", 'Project Status' = "Pipeline"), 'Estimated Start Date', 'Actual Start Date')
I have two data fields Actual Start Date and Estimated Start Date and want to create a single field Start Date which is determined by each row's Project Status. ie. Start Date should be default always show the Estimated Start Date until the Project Status changes from either Pipeline or Funnel, then it should show Actual Start Date.
The pivot table is connected to an external data source so I cannot add this calculation at the source. It also needs to be published into Excel Services and by dynamic so I cannot add the column 'outside the pivot'.
Can anybody help?
Thanks,
swhgraham
=if(or('Project Status' = "Funnel", 'Project Status' = "Pipeline"), 'Estimated Start Date', 'Actual Start Date')
I have two data fields Actual Start Date and Estimated Start Date and want to create a single field Start Date which is determined by each row's Project Status. ie. Start Date should be default always show the Estimated Start Date until the Project Status changes from either Pipeline or Funnel, then it should show Actual Start Date.
The pivot table is connected to an external data source so I cannot add this calculation at the source. It also needs to be published into Excel Services and by dynamic so I cannot add the column 'outside the pivot'.
Can anybody help?
Thanks,
swhgraham
