Show top 3 values per first dimension

[nesonica]

Hi guys,

I am failing at building the TOP3-dimension with the formula  

=If(Rank(Sum(TOP3-Category)) <=3, Sum(TOP3-Category))

as it would take ages to process all values. The plan is a table like this here:

Customer	TOP3-Category	Sales
A	Z	500
A	Y	300
A	X	200
B	X	400
B	W	350
B	Z	50
C	Y	1000
C	Z	200
C	X	100

Thanks in advance! Best regards.

Nes

[asinha1991]

put the second calculated dimension as

=aggr(if(rank(sum(sales))<=3,[Category]),[Customer],[Category])

[asinha1991]

attaching qvw, i used your data set and showed top 2 out of it, look at the top 2 pivot in qvw

[nesonica]

thanks so much but unfortunately i have no permission qvw. could you please explain? 🙂

[asinha1991 · Accepted solution]

create a straight table or pivot chart with two dimension

1. Customer

2.=aggr(if(rank(sum(sales))<=3,[Category]),[Customer],[Category])  (make sure field names are correct)

In expression

add your measure(sum(sales) for example)