Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
see this, the use case of Dimensionality()
May be look the Dimensionality() function.
Please look into Dimensionality() or SecondaryDimensionality()
see this, the use case of Dimensionality()