Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
in a pivot table I have a date like 01/01/2017
i need an expression like this
if (Dimensionality()=1,' ',
(if (Dimensionality()=2 and date>'01/06/2017',
'Hello'
)))
But it doesn't work (when i delete the condition of date it display hello...
regards
May be use Makedate() function
if (Dimensionality()=1,' ',
(if (Dimensionality()=2 and date>MakeDate(2017, 6, 1),
'Hello'
)))
Thank you sunny but it doesn't work
is date a true date field?
yes yes it's like 01/01/2017
Then no idea
Hi Zied,
May i know your dimensions?
I tried i can do with your expression when i put my date as my second dimensions.
You should try that.
But why you want to filter the date?
Regards
Marco