I stuck with an expression in calculating the AR, please check the data below
I am providing a Date object to select As of Date. Based on the selected date, i need to sum up the balance field by getting the amount Maximum Transaction# of an invoice.
Suppose if I selected date as 2/10/2012, for Invoice# 100 the AR is 800.
Suppose if I selected date as1/20/2012, for Invoice# 100 the AR is 900.
I have around 10 million invoices, so if I use Aggr() it is taking to much time to load the chart. Is there any other method to do this. I also tried FirstSortedValue(), but it is given me correct values when I used Invoice# as dimension, but my chart has no Invoice# dimension.