How to get data from excel to straight table

[bharatkishore]

Hello All,

I have an excel file data which is attached below. In that Excel sheet we have an field i.e. GVW_BAND. Now in that excel sheet under GVW_BAND we have an row i.e. 'ALL TONS'.

Now when i take a dimension GVW_BAND in straight table i am getting all rows except ALL TONS. Can any one please tell me how can i get that ALL TONS. That is the output i need to show.

But actually in my qvd if i take this GVW_BAND in a list box field only these values will be present.

Between 0 and 1

Between 1 and 5

Between 5 and 8

Between 8 and 16.20

Between 16.20 and 25

Between 25 and 32.20

Greater Than 32.20

So now i need one more i.e. 'ALL TONS' in that list box now i need total 8 in that GVW_BAND. Can anyone please tell me how to do.

Regards,

RBK

[#2]

we can create a calculated dimension in Stright table Like

if(GVW_BAND<>'ALL TONS',GVW_BAND)

~Kabilan K.

[bharatkishore]

Thanks for the reply.

In my orginal data if i take GVW_Band field in list box i will get values like shown below

  Between 0 and 1

  Between 1 and 5

Between 5 and 8

So it will be containing upto Greater than 32.20(i.e. total 7 values)

Now i need one more that should be present with All Tons.

So now if i take this GVW_Band as a list box i need all the values including 'ALL Tons'(now total 8 values).

[#4]

Hi,

Pls Refer this Attachment..

..

[jagannalla · Accepted solution]

Hello,

May be this file will help you. Please check it.

Cheers!!

Jagan

[bharatkishore]

Thanks a lot Jagan.

Regards,

R. Bharat Kishore

[bharatkishore]

Thank you Kabilan.