How to link new excel file to existing data model

[prma7799]

Hi All,

I have one application which is based on link table concept.

I have one requirement in application i want target value which present in attached file.

Can anyone suggest me that How can I start.

I started to work on it but not getting success on selection . I faced one issue that I got target values but when I select any Month or Quarter or Year then Target values not changed.

Thanks

[tresesco]

Could you post a screen shot of your data model?

[vikasmahajan]

Prashant  use this following formula to get correct sales of last year jan

Sum({<DATE={">=$(=MonthStart(Max(DATE),-12)) <=$(=MonthEnd(Max(DATE)))"}>} SALES)

[prma7799]

Sir...

You are right but this is different question.

Thanks