Last Day of month

[Anonymous]

Hi Guys,

I need one help..My scenario something like this,I have a Chart in which dimension is cyclic group of calendar and another dimension cyclic group of Country and City . I have expression as sum(Sales).

My requirement is when i select Country in cyclic group I should get sum(sales)by Last day of period/month but when i select City it should display sum(sales)by period

[tresesco]

May be something like like this?

If(getCurrentField(YourGroup)='Country', Sum({<Date={'$(=Max(Date))'}>}Sales) , If( .....

If this does not help, please share a sample app.