Need to show actual and future data together

[#1]

Hello Everyone,

Can anybody please help in this,

I am creating one chart, in one expression I need to use two sources.

Like for actual data I need to get from one source, for future data I need to get from another source. What to use in the expression. I am trying like If year<max(year), then source 1 if Year>max(year) then source 2, but not working.

Please help in that.

Thanks in advance

[#2]

Anything wrong in this expression,

=if(SegName='Name1' and DATE<=$(vToday),RevenueCY),RevenueLY)

i am getting only the value from else statement.

Thanks

[DavidFoster1]

The approach a lot of people use is to concatenate the two datasets together to create a single facts table. You can then create expressions on the same table.

[#4]

Try this

=if(SegName='Name1' and DATE<=$(vToday),RevenueCY,RevenueLY)

I just removed the bracket after RevenueCY

[#5]

Yes David,

I have combined fact table, with two data sets, i created expression on the same table, still it is having the problem

[#6]

Hi Vidhya,

It is not working, still getting the Revenue LY value

[#7]

Can any body please look into this and help,

is there any other way to show future and history data together.

Thanks