Straight Table Issue

[Anil_Babu_Samineni]

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 ..

[tamilarasu]

Use RecNo() function in your load script. Add the Recno column in straight table and go to presentation tab then hide it. Check the attachment for better understanding.

Load *, RecNo() as RecNo;

LOAD * INLINE [

    Country, Sales

  India,  5000

  Us, 2500

  Uk, 4000

  India, 5000

  Us, 5500

  India, 4500

];

[Anil_Babu_Samineni]

Tamil,

Thanks for Attempting..

I want to show o/p like below, Please review my required O/P

Country          Sales

India              5000

India              5000

Here, I don't want to show 4500 Data....

Updated : My Client allowed to show Duplicates as well ....

[Anonymous]

Hi Anil,

I guess Country is the dimension. You can make it calculated dimension similar to

If(Country = 'India', Country)

Good Luck

[Anonymous]

Oh, I forgot the 4500 row ... then the Expression for Sales might be if(Sales > 4500, Sales) ...

... or probably Sum({<Sales = {'>4500'}>} Sales)

[tankut_kocabas]

Hi,

You can try this

Temp:
LOAD * INLINE [
Country, Sales
India, 5000
Us, 2500
Uk, 4000
India, 5000
Us, 5500
India, 4500
];

Temp1:
NoConcatenate LOAD Country, Sales
Resident Temp
WHERE Country = 'India';

DROP Table Temp;

[tamilarasu · Accepted solution]

ANil,

Check the attachment.

[HirisH_V7]

Hi,

May be these ways,

1. Dimension:

      =IF(Match(Country,'India'),Country)

      Expression:

        =IF(Sales<>'4500',Sum(Sales))

    2.

    Only expression:

Sum({<Country={'India'},Sales-={'4500'}>}Sales)

Can You please elaborate your requirement do you require the values above 5000 for india or what you can specify that condition in the expression itself or in script itself you can handle it using where condition.

Hope this Helps,

PFA,

Hirish

[Anil_Babu_Samineni]

Tamil,

Perfect..

Sometimes, Client need only India data.

Note: They can allow Duplicates as well.

My task is finished. Do favor for me..

I want to show like this

Country            Sales

India                 5000

India                 5000

India                 4500

[#10]

Hi,

See the attached.