Avoid Data Island

[parpatra]

Hi,

I have a huge data set (> 2million) and have a requirement to show sum(Amount) in current month divided by sum(Amount) in all previous month except current.

I was able to implement this using an unconnected date table and used expression like sum(amount) where month=currmonth and sum(amount) where month<current month.

Now since the data set is huge, I want to avoid use of an unconnected table.

Kindly suggest me some approach.

Thanks in advance!!

[#2]

John,

Been browsing the Community for a better understanding of Islands and stumbled on your post.

Very simple very elegant.

I just used it and I wanted to say thanks.

Rich De Rocco