Expression

[nareshthavidishetty]

Hi ,

I have used the below logic as calculated dimension . Based on the highlighted condition

Here i need to get the Inovice_num only for one day ie.,if Date= varMaxDate i need to show only those invoice numbers.

Logic: =Aggr(If((SUM({<Date={$(varMaxDate)},flag={'eSign'},Category={'Not Complete'}>}Sales) > 0),Inovice_num),Loc,APA0TX,Inovice_num)

Thanks..

[sunny_talwar]

I guess this:

=Aggr(If(Sum({<Date = {'$(=varMaxDate)'}, flag = {'eSign'}, Category = {'Not Complete'}>} Sales) > 0 and Date = $(varMaxDate), Inovice_num), Loc, APA0TX, Inovice_num)

We won't really know if you get what you wanted just by looking at this expression. I would suggest to share a sample so that we can help you better

[nareshthavidishetty]

how to post application securely

[vishsaggi]

Follow this and upload your sample app:

Preparing examples for Upload - Reduction and Data Scrambling