9 weeks weekly data to be displayed

[#1]

Hi,

I'm working on the trends to be displayed for 9 weeks data. This is the formula i've used for the calulation. But seems its not working. Can you please help me out of this issue.

Formula used :

  sum({<CalYear=,Weekend=,[Month Year]=,date_con ={'>=$(=addmonths(min(date_con),-2))<=$(=max(date_con))'},[Metric_ID] ={'A_002'} >} Result

)/1000

Regards,

Archana.

[kaushiknsolanki]

HI,

     Archana try below code.

sum({<CalYear=,Weekend=,[Month Year]=,date_con ={'>=$(=addmonths(min(date_con),-2))<=$(=max(date_con))'},[Metric_ID] ={'A_002'} ,Month=,Year=,>} Result

)/1000

     You must deselect the Date dimension when you are trying to get the data against the selection made.

     So as shown in above expression kindly deselect the month and year selected.

Regards,

Kaushik Solanki

[#3]

Is data_con field in the same format as your default DateFormat?

eg 'YYYY-MM-DD'

[#4]

Hi alex,

The date format is DD-MM-YYY.

[#5]

Was i saying that field date_con must be in the default date format for your document.

Also if you post example file it wold be easyer to solv your problem.