Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
how can i show expresion in some condiotion with set analysis in pivot for exm.
i want to show date feild for only when feild="tostr" and code="3".
how can i use set analysis with no : sum,avg... ?
thanks'
yarin.
Try something like this
max({<feild = 'tostr', code = '3'>} Date)
or
only({<feild = 'tostr', code = '3'>} Date)
Regards
ASHFAQ
Hi,
Try like
Sum({<feild = 'tostr', code = '3'>} Metrics)
Regards
Anand
my Metrics is date , when i write smu the date is change.
do you have any idea ?
mybe there is another function not sum ?
thanks'
yarin.
Try something like this
max({<feild = 'tostr', code = '3'>} Date)
or
only({<feild = 'tostr', code = '3'>} Date)
Regards
ASHFAQ
Hi,
Then try like
Only ( {<feild = 'tostr', code = '3'>} Date )
Or
In the calculated dimension for Date like
If( feild = 'tostr' And code = '3', Date)
//And select Suppress When value is NULL
Regards
Anand