Double rankings

[Anonymous]

Hi,

in attach, you can find a sample data related to a problem of ranking.

I have two tables in front end, with two different expressions and the same dimension (customer): I would like to create a table with customers' rankings

Thank you!

Elena

[MK_QSL]

Create a Straight Table

Dimension

CUSTOMER

Expression

For PURCHASE Rank

IF(Num(Rank(TOTAL SUM({<CUSTOMER = {"=SUM(PURCHASE)>0"}>}PURCHASE),4))<=Count(TOTAL{<CUSTOMER = {"=SUM(PURCHASE)>0"}>}DISTINCT CUSTOMER),

Num(Rank(TOTAL SUM({<CUSTOMER = {"=SUM(PURCHASE)>0"}>}PURCHASE),4)))

For TICKET Rank

IF(Num(Rank(TOTAL COUNT({<CUSTOMER = {"=COUNT(TICKET)>0"}>}TICKET),4))<=Count(TOTAL{<CUSTOMER = {"=SUM(TICKET)>0"}>}DISTINCT CUSTOMER),

Num(Rank(TOTAL COUNT({<CUSTOMER = {"=COUNT(TICKET)>0"}>}TICKET),4)))

[sunny_talwar · Accepted solution]

This?