Find Largest Value In Category And Subcategory

[#1]

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

[crusader_]

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

[#3]

Look like

[tresesco]

PFA

[crusader_]

You need to change expression a bit.

PFA example.

Regards,

Andrei

[#6]

Thanks But is not valid

for example : Bike-->Road Bikes In highest No mountain bikes

[crusader_]

Then use tresesco‌ approach.

Regards,

Andrei

[kavita25]

Check the qvw

In calculated dimension use the below logic:

=If(Aggr(Rank(Aggr(Sum(SalesAmount), EnglishProductCategoryName, EnglishProductSubcategoryName)), EnglishProductCategoryName, EnglishProductSubcategoryName) <= 1, 

EnglishProductSubcategoryName) 

Regards,

Kavita