
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Plz help me regarding finding the top 10 highest amount in using pivot table and also in table box
Plz help me regarding finding the top 10 highest amount in using pivot table and also in table box?
I am using the following expression but i'm getting only first 4 values correct.....
if
(aggr(rank(sum(amount)),amount)<=10,product_category
)
- « Previous Replies
-
- 1
- 2
- Next Replies »

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
HI,
PFA
Regards,
Nirav Bhimani

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Try This Expression to make it dynamic
In Expression:
sum({<Customer={"=rank(sum(Sales))<=$(=vTop)"}>} Sales)
Or In Dimension:
If(AGGR (rank(sum(Sales)), Customer) <=10 , Customer)
Or
If(AGGR (rank(sum(Sales)), Customer) <=$(=vTop) , Customer)
Reagrds,
Nirav Bhimani

.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Please find attached file for reference. Also it is not possible to restrict Top n in Table box, you can use Straight table instead of Table box.
Hope this helps you.
Regards,
Jagan.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi,
I'm using personal edition so ur file will not be opened.....so plz do write expression in reply....

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi,
I'm using personal edition so ur file will not be opened.....so plz do write expression in reply....

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi,
I'm using personal edition so ur file will not be opened.....so plz do write expression in reply....

.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
I have a dimension called TEST in my datamodel, for this I used
Calculated Dimension = aggr(if(rank(FAILURE)<6, TEST),TEST)
Expression = Sum(FAILURE)
The above displays the top 5 Tests which has highest failures.
Hope thie helps you.
Regards,
Jagan.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
HI,
For the expression see my earlier post .
Reagrds,
Nirav Bhimani

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I am using 3 columns (amount,product category and potential name).
I want top 10 highest values from amount column.
I used the formula in both calculated dimension and in expression but im getting wrong result....
might be because of supress zero values checkbox....
If i deselect the Supress zero value then i get the specified result but here top 10 values are not coming , whole data is displayed......

- « Previous Replies
-
- 1
- 2
- Next Replies »