-
1. Re: MAX for Running Totals
Joshua Milligan Aug 22, 2016 9:08 AM (in response to sachin.kambli.0)Sachin,
I would suggest using a filter based on Last(). When calculated along Customer ID (Like your other table calcs), Last() will equal 0 for the rows you desire to show.
Probably, the easiest way is to create a calculated field with code LAST() == 0, make sure it's giving you the results you want (True on the last rows) and then move it the Filters shelf and keep True.
Hope that helps!
Joshua
-
2. Re: MAX for Running Totals
Joshua Milligan Aug 22, 2016 9:12 AM (in response to sachin.kambli.0)Wait, I just realized that won't work because you are already using a table calc filter that's eliminating the last ones.
So, it gets more complicated!
If you were to add logic to the [% of Region Sales] field that returned null as soon as it is greater than your parameter, then you could create another calculation that checked:
WINDOW_MAX([% of Region Sales]) == [% of Region Sales]
And keep only True
Hope that helps!
Joshua