- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Find Largest Value In Category And Subcategory
hello dears
i want find largest value in Category And Subcategory then data is filter (Create New Dimension Of Largest SaleAmount)
i want show table that include highest value Per Subcatgory (i want show Category,Subcategory,Highest Value ,each category have multiple Subcategory)
For example :
Bike-->Road Bikes -->14520584
Accessories-->Tires And Tubes -->245529
plz help me
file is attach
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Please explain why the table on the right is not "right"?
Also, please show your expected result in simple table (Excel). It helps others correctly understand your requirements.
Thanks in advance.
Regards,
Andrei
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Look like
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
PFA
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You need to change expression a bit.
PFA example.
Regards,
Andrei
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks But is not valid
for example : Bike-->Road Bikes In highest No mountain bikes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Check the qvw
In calculated dimension use the below logic:
=If(Aggr(Rank(Aggr(Sum(SalesAmount), EnglishProductCategoryName, EnglishProductSubcategoryName)), EnglishProductCategoryName, EnglishProductSubcategoryName) <= 1,
EnglishProductSubcategoryName)
Regards,
Kavita