how to show the Previous Rank in straight table.

[rkpatelqlikview]

Hi Experts,

Please help on this.

Below is my expression in in straight table for Rank.

=

Aggr(

rank(

(Round(sum({<[Safety Category]={'Green'}>} [Kms Travelled]) / sum([Kms Travelled]) *100)/4)

+(Round((COUNT(DISTINCT [DEVICE NO]) -COUNT([Device Number]))/COUNT(DISTINCT  [DEVICE NO]) *100 )/4 ) +

(Round(SUM({<controlled={'Yes'}>}Quantity)/SUM({<controlled={'Yes'}+{'No'}>}Quantity)*100)/4)

+

(Round(SUM({<[iVMS ( Y/N)]={'Yes'}>}Quantity)/SUM({< [iVMS ( Y/N)]={'Yes'}+{'No'}>}Quantity)*100)/4)+sum([Kms Travelled])/(1E10)

,4,1),Group, [Carrier Name])

If i select this month in other expression it should be Previous Rank..

Please let me know if you want more info.

[sunny_talwar]

Not sure I understand... can you pin point the exact issue? May be provide the exact number you are looking to get?

[bc-thebruuu]

Last Rank = count

Am I right?

Can yo provide an expected result?

[rkpatelqlikview]

Sure Sunny / Bruno,

Please find the below 2 images. Here CarierName "Sainath Transporter" is Rank 1.

Now i selected the month March then that "Sainath Transporter" is Rank is 7. This Rank it should show in Previous Rank column.

[bc-thebruuu]

Is previous wrt to previous selection or previous month?

[sunny_talwar]

Would you be able to share a sample where Jan have some data?

[sunny_talwar]

I believe previous month... so when March is selected, show Feb's Rank in Previous Rank

[rkpatelqlikview]

Yes Exactly. Previous month

[rkpatelqlikview]

sure

[bc-thebruuu]

Anyway ..

I think that Overall Rank should contain in each set analysis a constraint on

MonthYear to be  max possible month

and previous montth should be max possible month -1

[rkpatelqlikview]

I need to write an expression for month.  There is Quarter and Year as well.