Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have the following expression :
if([Type de commande] = 'URGENT' or [Type de commande] = 'GROS' or [Type de commande] = 'PVI' ,Aggr( count([N° de commande]),[N° de client]),1)
And I want to calculate the order number for each customer number
And thank you in advance
May be this in your expression:
= Sum(Aggr(Count(if(Match([Type de commande], 'URGENT','GROS', 'PVI'), [N° de commande])),[N° de client]))
Where are you doing this? In a chart with client as dimension or somewhere else?
May be this in your expression:
= Sum(Aggr(Count(if(Match([Type de commande], 'URGENT','GROS', 'PVI'), [N° de commande])),[N° de client]))
thank you Vishwarath Nagaraju The exercise was resolved