4 Replies Latest reply: Apr 18, 2014 4:14 AM by Dariusz Mielczarek RSS

    Problem creating the report to show only latest status of the project

    Nikita Chumakov

      Hi, everyone,

       

      I am creating project management tool and do collect daily updates from project leaders. Let's assume task 10 was named as "Develop detailed plan" on 1 Jan 2014 and next day description has changed to "Develop detailed strategic plan". I want to create pivot chart where only latest possible descriptions will be displayed. My idea is to create calculated dimension to compare current date of record with max date possible for this task, and set to Null if it's not for further surpression. However I can't make it work. I have tried to illustrate this below:

       

      Any help will be very much appreciated.

      17-04-2014 12-58-10.jpg