-
Re: Rank list items based on multiple ranking levels
Hi @LouiseBourgonjon Would this solve your problem? Create new (third) line item that takes: (100 x )+ <Line item 2> i.e. (100 x 'Rank by Vendor Total' )+ 'Rank within vendor' This way all your…1 -
Re: 4 Quarter Average for a year
The recommended ways of doing it would be to use the summation or have an intermediate year only item. If you're really short of space you can use TIMESUM(a, <FY-Q1>, <FY-Q4>) / 4 where Q…1