Display only the Sales with highest SL's

[satishkurra]

Hi

In the below data, i need to display only SL's with highest Sales.

For example, INDIA has highest SL for SL3. I should be displaying only 1500 against INDIA and SL3

In the same way USA has highest SL for SL1. I should be displaying only 3000 against USA and SL1

I'm trying to achieve this in a Pivot Table by dragging the SL column to show column wise...

LOAD * Inline [

Country,SL,Sales

INDIA,SL1,1000

INDIA,SL2,900

INDIA,SL3,1500

USA,SL1,3000

USA,SL2,1000

USA,SL3,2000 ];

Can someone help me on the same?

Thanks

Satish

[satishkurra]

In b/w i'm using Dimension 1 as Country, Dimension 2 as =FirstSortedValue(SL, - aggr( distinct  sum(Sales),SL ) )

and expression as Sum(Sales)

[sunny_talwar]

How about using two expression and one dimension in a straight table?

[sunny_talwar · Accepted solution]

Or this where expression is Max(Sales) instead of Sum(Sales)