Forum Discussion

rpn7kor's avatar
rpn7kor
Frequent Visitor
6 years ago

Graph using multiple columns in X axis

Dear Together,   I got a requirement to create a graph to represent the project growth. I tried with some measures and tables. But couldnt get the desired output. So need your support.   We have ...
Need Help
  • rpn7kor's avatar
    rpn7kor
    Frequent Visitor
    6 years ago

    Dear amitchandak ,

     

    Thanks for your guidance.

     

    I have tried as per your blog. Still i have one issue about total projects. i would like to show total project in incremental way like below.

    Year 20142015201620172018
    Running22323
    Closed 11 1
    Total 22456

    Is there any clue?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi rpn7kor ,

      Could you please provide the calculation logic of Running and Total? For example: Year 2018, why the number of running projects is 3, but the total number of projects is 6? How to calculate them?

      Best Regards

      Rena

      • rpn7kor's avatar
        rpn7kor
        Frequent Visitor
        6 years ago

        Hi Rene,

         

        Thanks for your message.

         

        Year 20142015201620172018
        Running (Current year + previous years) 22323
        Closed (which are completed) 11 1
        Total Projects (Current year + previous years)22456

         

        For example , 2018 has total of 6 projects (2 from 2014 + 2 from 2016 + 1 from 2017 + 1 from 2018)

                               and has 3 running projects (total project - closed projects)

         

        Thanks.

  • rpn7kor's avatar
    rpn7kor
    Frequent Visitor
    6 years ago

    No...:(