TOP 5 in PIVOT TABLE

[MK_QSL]

I have sales table for different branches…

What I need is a pivot table with Dimensions

Branch Code

Sales Operator

Month

Expression : SUM(Sales)

I need a pivot table showing top 5 sales operator of each branch and their monthly sales achievements.

If I select Branch 01... result would be something like below...

Branch Code	Sales Operator	Month	Total	May	April	August	July	June	September
Branch 01	pshan		105,706	15,139	15,876	27,376	18,801	17,567	10,948
Branch 01	keitr		72,902	12,919	9,577	14,460	10,908	12,481	12,556
Branch 01	tferg		64,920	14,596	13,680	6,739	16,985	11,479	1,442
Branch 01	fiqba		57,937	8,505	6,771	10,878	10,780	8,714	12,289
Branch 01	antoc		42,601	8,358	6,045	7,233	9,711	6,082	5,172

[Anonymous]

I have used below expression but it is not wrking

=if(AGGR(RANK(SUM(Sales,GetCurrentField('GroupName')<=5,GetCurrentField(GroupName'))

[MK_QSL]

Try this

if(Aggr(Rank(SUM(Sales)),$(=GetCurrentField(GroupName)))<=5, $(=GetCurrentField(GroupName))

[vipin_mishra479]

Hi manish,

Use This qvw.