Complex logic

[smilingjohn]

Hi All,
I have a pivot table with many columns into it . for this table I have requirement of showing those  Sub-category whose date is a future date.
If you look at the screenshot I have horizontally placed the dimension "MODE" ( Mode1-prod,Mode2-Prod,Mode3-Prod) .

So my requirement is like to display the Sub-Category for future date is as long as in all the mode's (that is Mode1-Prod to Mode3-prod)
any one mode is holding future date then the complete row should be displayed .
To do this I am trying to use this logic

If(Date>=Today(),Sub_Category) but this logic is considering only Mode3-Prod date as shown in the screenshot below .
I need to display all the dates as long as any one mode date is current date or future date .

Need you help on this 

Thanks IN Advance 

[smilingjohn]

I tried something like this  but this don't work 

If(Date>=Today(),Sub_Category) or  if(Date>=Today() and Date<today(),Sub_Category)

Thanks

[smilingjohn]

Hi All,

Any help / suggestion on my above post 

Thanks 

[Digvijay_Singh · Accepted solution]

Not sure but may be try something like this in the MODE dimension - 

if(Max(Aggr(Date,Product,Category,Sub-Category,Mode))>today(1), MODE)

May be similar kinda expression for Sub Category.

If you share sample data, quite possible someone would give solution or guide better.

[smilingjohn]

Thanks @Digvijay_Singh  

I tried you logic but this doesn't work ..I tried even for Sub Category. 

[smilingjohn]

@Digvijay_Singh  sorry my mistake 

Yes your log works and it is giving me the accurate results thanks a lot sir