3 Replies Latest reply: Apr 12, 2016 11:33 AM by kushal chawda RSS

    Pivot table total with missing values

    Pekka Laaksonen

      Hi,

       

      Is it possible to change pivot table total row value depending on what kind of data is available? I have a table where I need to show earliest project information update dates. If the date is missing, the row should say "not updated". If multiple projects are chosen and one project in the group has missing update date, pivot table's total row should also return "not updated".

       

      It's easy to show date value if it exist and "not updated" if it doesn't exist:

       

      if(isnull([Update Date]), 'Not updated', min([Update Date]))

       

      However the total row also displays a value that results from min([Update Date]. Is there way of telling total row to ignore date field if there are missing values in selected group?