Data inconsistency

[nikhilgarg]

Hey,

I have a qstn.

I have following data:

Col1     Col2    Col3   Col4   Col5  Total 

212       ABC    0       12        0        12

212       ABC    0       11        0        11

212       ABC    0       0         9        9

212       ABC    64      0        0        64

I want all these multiple entries to come in a single line like:

Col1     Col2    Col3   Col4   Col5  Total 

212       ABC    64      23        9         96

How can i obtain this??

thanks

[nikhilgarg]

Under State column i want only SPOT/FORWARD value

[robert_mika]

Your data set does not contain those fields/values.

[nikhilgarg]

Hey,

I have pivot table. In that i have an expressn(Col3). I want the data to be shown in pivot as per ascending value of Expressn colmn(col3) . How can i acheive this ?

[robert_mika]

Look here:Sorting in pivot tables

[nikhilgarg]

Hey,

Thanks but now it is showing rank for following values as:

%Accepted        Rank

66.67%               1-3

66.67%               1-3

66.67%               1-3

50%                     4

It sld be like :

Rank

1

1

1

4

how to acheive this?

[kaushiknsolanki · Accepted solution]

Try this.

=rank(total count({<Source = {'Accepted', 'ClientAccept', 'DealerAccept'}>}Source)/count({<Source = {'Accepted', 'ClientAccept', 'DealerAccept', 'Rejected', 'Timedout'}>}Source),0,1)

Regards,

Kaushik Solanki