How to create Sales Last year to Date

[#1]

Hello all,

In the red markered column in straight table there's no Sales data. I expected in this column sales data based on  startdate 01-12-2014  and enddate 31-12-2014).

Which set analysis / script codes should i use to get the data in the red markered column?

Thank you very much.

Greets,

Rega

[#2]

Hello Onno,

Sorry but i cant see the field or button ""Use advanced editor"

Can you show me ?

[oknotsen]

Click on "reply" (bottom right corner).

After that you see the screen as in the attachment to this post. The arrow points to "advanced".

The 2nd attachment points to the "attach" button.

[sunny_talwar]

Step 1:

Step 2:

[Anonymous]

I cannot provide the QVW file as it contains proprietary information.

In order to create the FLAGS as previously described you will need to create a calendar dimension that can be joined to your fact table.

[#6]

Hey Sunny,

Whats the latest status? Do u have  the solution?

Thanks

[koushik_btech20]

Hi Rega,

Try to share small application in community with less data.

Regards,

Koushik