Pivot table total with missing values

[#1]

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?

[settu_periasamy]

May be look the Dimensionality() function.

[trdandamudi]

Please look into Dimensionality() or SecondaryDimensionality()

[Kushal_Chawda · Accepted solution]

see this, the use case of Dimensionality()

Custom total calculation in Pivot table