show feild in pivot

[Anonymous]

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.

[its_anandrjs]

Hi,

Try like

Sum({<feild = 'tostr', code = '3'>}  Metrics)

Regards

Anand

[Anonymous]

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.

[ashfaq_haseeb · Accepted solution]

Try something like this

max({<feild = 'tostr', code = '3'>}  Date)

or

only({<feild = 'tostr', code = '3'>}  Date)

Regards

ASHFAQ

[its_anandrjs]

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