Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
help me with the If statement ....I have salespersons in a chart with months so I want to see how 1 sales person is performing against other salespeople in each month
Thanks
Try this
if(SalespersonName='Palesa',Aggr(NODISTINCT Sum({<SalespersonName={"Pol"}>} SalesAmount), Month), sum(SalesAmount))
Regards,
Chinni Kanna