Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
below expression not working in calculated dimension but it's working in expression. kindly advise me. thanks
=if((Count({<Year={'*'},Week={'*'},Type_ID={'RO'}>} distinct OrderQty))>0, 'Repeat', '-')
Note: used pivot table
Regards,
Dev
Hi Anil,
Issue resolved,
=Aggr(if((Count({<Year={'*'},Week={'*'}>}distinct OrderQty))>0, 'Repeat', '-'),ArticleNo)
Would you provide sample to work, Why it's not working because you can't do direct count in Dimension level. Might require aggregation function. Can you share the application?
Hi Anil,
Issue resolved,
=Aggr(if((Count({<Year={'*'},Week={'*'}>}distinct OrderQty))>0, 'Repeat', '-'),ArticleNo)