Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi.
i want to show the sales of customer in the chart only if the customerid exist in current as well as next year otherwise, i want to ignore those ids.
i want to do this in front end...
please help
attached example
Gautham
Hi,
Try this.
=sum({<Customerid=p({<Period = {'2015'}>}),Period = {"2016"}>}Sales)
It says give me all the customers of 2015 and then for those customer give me sales of 2016.
Regards,
Kaushik Solanki
Thanks kaushik,
This works for second expression, but for first expression no. I want the sales for customerids which exist in both periods.
please find the attachment..
Hi,
What i understood is an intersection, so you need to add a * in the expression
=sum({<Customerid * =p({<Period = {'2015'}>}),Period = {"2016"}>}Sales)
Try this.
Sum({<Id = p({<Year = {"2015"}>})>*<Id = p({<Year = {"2016"}>})>}Sales)
Regards,
Kaushik Solanki
May be this for a more dynamic expression:
=Sum({<Customerid=p({<Period = {$(=Max(Period))}>})*p({<Period = {$(=Max(Period)+1)}>})>} Sales)