Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have table like below
LOAD * INLINE [
Country, Sales
India, 5000
Us, 2500
Uk, 4000
India, 5000
Us, 5500
India, 4500
];
So, Now i want to show Straight table like below
Country | Sales |
---|---|
India | 5000 |
India | 5000 |
Note: Please send me the Expression using Set Analysis ....
Please help me, I Appreciate your Help ..
Try like this
sum({<Country={'India'}>}Sales)
Anil,
Sorry for the late reply, I was busy with work. Please check new attachment.