must be good in creating excel pivot chart

profilecarl231

i attached an excel sheet here with some data , i need to create a pivot chart for the data in that excel to show the following


 

 1)Total Numbers of projects with  construction Start (con299) in 2018 that ends  in year 2018  (construction complete) ie must have same project id

3)Total Numbers of Projects with  Construction Start in 2018 and construction complete in 2019 – Roll over project 

4) Total Numbers of Projects for Start construction in 2019 and Construction Complete in 2019 à 

5) Need to Include Mat Type

6) Need SAP Status

7) Need Phase for activity start and finish


read and ask questions if before you send me a message

Thanks

  • 5 years ago
  • 20
Answer(1)

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    pivotcharts.xlsx
  • attachment
    pivotcharts.xlsx