Aggr for Two dimensions

Tue, 06 Sep 2011 11:38:33 GMT

Hi all..

I would like to display a top in opposite from 2 dimensions.

In my case, I would like a top 10 (Sales) of Products by Activity of Customer :it's ok.

I input these function in used dimensions:

1 - Activity of Customer

2 - Product (with formula:

If(aggr(rank(Sum({<DATELIV={"$(='>=' & date(vStartDate1) & '<=' & date(vEndDate1))"}>}Sales)),Product)<=10,Product)

and in expression :

Sum({<DATELIV={"$(='>=' & date(vStartDate1) & '<=' & date(vEndDate1))"}>}Sales)

My problem, It's to recuperate those data and to put them in other dimension :The country.

In order : Country/Activity of Customer/Top 10 Products.

I didn't arrive to input this dimension at the top of used dimension because the filters are applied under the sub dimensions.

Can you help me?

Thanks by advance

Bye

Michael

suniljain — Tue, 06 Sep 2011 11:40:16 GMT

aggr( sum(Sales), Country, Region )

Tue, 06 Sep 2011 12:39:05 GMT

Thanks Sunil

I also tried this function but I didn't arrive to put correctly in function of my structure.

(I m a beginner).

I put this at the top of the used dimension?This function will implicate the aggr() in the sub dimension.

Thanks a lot.

topic Aggr for Two dimensions in QlikView