Pivot chart displaying of particular number of dimensions

[rohitians]

Hello,

I have this pivot table where in i have Companies with their brand names ,I am diplaying sales of this brands CYvsLY..

Now the scene is i want to show only a particular number of brands i.e input box the user may select i want to see only top 3 brands of all companies

so as per the number only 3 top selling brands should be displayed for each company and total sales for that company should be dispayed...

I am attaching a sample qvw file in order to get an idea of the report...

and is it possible to achieve the same...

Thanks and Regards,

Rohit

[#2]

Please check the attached app and confirm whether it satisfies your requirement

[rohitians]

Hello Vikram,

It's actually what i wanted...

But only one problem suppose i choose 10 it shows 10 brands and shows total of all the rest brands but with no label it shows - ..else everything is bang on..

Hope you are doing good..

Thanks and Regards,

Rohit

[tresesco]

Are you looking for this?

[rohitians]

No tresesco,

Go through app posted by Mr Vikram you would to kno what I am asking...

Thanks and Regards,

Rohit

[rohitians]

Hey Jatin

When I want to use a cyclical group instead of a single field company and the following is the code,

=if(aggr (rank (SUM({$<FinancialYear=,Quarter=,MonthName=,FiscalYear={$(=max(FiscalYear))},

Date={">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear))}>} Date),0,4))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>} Date))"}>}Values

/10000000)

),GetCurrentField(Co-Thr),BRAND)<=$(vTopBrands),BRAND)

Is this the right way,

Thanks and Regards,

Rohit

[#7]

Hi Rohit ,

try something this

=if(GetCurrentField(New)='COMPANY',

if(aggr(rank(sum(CY)),COMPANY,BRAND)<=$(Top),BRAND)

,if(GetCurrentField(New)='BRAND',

if(aggr(rank(sum(CY)),BRAND,BRAND)<=$(Top),BRAND)))

New --- Name of Cyclic group dimesnion

[#8]

TRY THIS,

=if(aggr(rank(sum(CY)),

$(=if(GetCurrentField("cc_grp") = 'COMPANY', 'COMPANY',

if(GetCurrentField("cc_grp") = 'COMPANY1', 'COMPANY1',

if(GetCurrentField("cc_grp") = 'COMPANY11', 'COMPANY11'

))))

,BRAND)<=$(Top),BRAND)

[#9 · Accepted solution]

=if(aggr(rank(sum(CY)),$(=GetCurrentField(New)),BRAND)<=$(Top),BRAND)

[rohitians]

Hello Vikram, Jatin

Thanks for helping

=if(aggr(rank(sum(CY)),$(=GetCurrentField(New)),BRAND)<=$(Top),BRAND)

this code is working...

Thanks and Regards,

Rohit