Set Analysis based on Rank

[yossi_bire]

Hi,

I'm struggling with this issue for several days.

I want to calculate the Total value of the N customers with the same conditions.

Meaning, first calculate the total sale per Customer with some conditions (set analysis), then rank them, and finally sum the total sales for the first N top customer. the N is a variable the can be changed by the user.

somthing like this

sum(<{Field1={''},field2={''}, Customer = { Rank( sum(< {Field1={''},field2={''} > Sales } <= $(NTopCustomer))} Sales)

thanks

[sunny_talwar · Accepted solution]

Try this

Sum({<Field1 = {''}, field2 = {''}, Customer = {"=Rank(Sum({<Field1 = {''}, field2 = {''}>} Sales)) <= $(NTopCustomer)"}>} Sales)

[yossi_bire]

at first, it didn't work, but I found out what was the problem

one of my conditions is based on a variable

[DATE.autoCalendar.QuartersAgo]={"<=$(DateRangeSelection)"}

your answer works perfectly without it, any suggestion?

[sunny_talwar]

What are Field1 and field2? Are these placeholders for your actual fields or that is what they are called? If they are the real field names, make sure you have the correct casing for them... meaning is field2 called Field2? or may be Field1 is called field1...

There could be many things which could be not right... difficult to say what might be issue more details. Are you able to share a sample if what I mentioned above is not an issue

[yossi_bire]

my conditions are

[DATE.autoCalendar.QuartersAgo]={"<=$(DateRangeSelection)"} , [CHANNEL]={'DIRECT'}

[sunny_talwar]

May be try one of these

[DATE.autoCalendar.QuartersAgo]={"<=$(=DateRangeSelection)"}

or

[DATE.autoCalendar.QuartersAgo]={"<=$(=$(DateRangeSelection))"}

[yossi_bire]

nope still -

[sunny_talwar]

How do you define DateRangeSelection?

[yossi_bire]

it's working in the set analysis outside the Rank

it's a variable that gets the value from the extension "Variable Toggle" and the options are:   0 , 3 , 7

[sunny_talwar]

Have you checked that the variable actually takes a value once you set it using your extension? Check the variable overview and see what value do you see for DateRangeSelection variable