Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have sample data as shown below.
I want to create a straight table with country as dimension. I want to show sum sales for each country, but only the top 3 sales.
Country Sale
A 5
A 2
A 3
A 7
A 1
B 9
B 2
B 3
B 12
B 4
C 15
C 2
C 1
C 7
C 8
Desired Output
A 15
B 25
C 30
How to achieve this?
This is perfect... Thank you.
Ankit,
Like this???
Thanks,
AS
pfa,