Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Im using the P&L pivot and i want to change the measure label depending in the name of the dimension
i try with the if function but i also have nulls as a result
here is my code
if([sales flash]='current month','actuals','credit hold')
please find attached a image
Hi
try using ISNULL() and or in your condition according to your requirement
Hope this info helps
thanks