Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for
Search instead for
Did you mean:
Specialist

## Complex logic

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

Labels (6)

• ### Set Analysis

1 Solution

Accepted Solutions

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.

5 Replies
Specialist
Author

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

Specialist
Author

Hi All,

Any help / suggestion on my above post

Thanks

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.

Specialist
Author

Thanks @Digvijay_Singh

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

Specialist
Author

@Digvijay_Singh  sorry my mistake

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