I Want see single row

[kulasekhar]

Hi All,

Bellow pivot table i had one ITEM_NUMBER have 1 or more SPECIFICATION_NUMBER and one SPECIFICATION_NUMBER have 3 or more ITEM_NAME.

http://

I want to see single row.

Please give me idea.

Thanks

Sekhar.

[Anil_Babu_Samineni]

You have Item_Name is different different names. So then? And you want to keep 81 and 87 too?

[tresesco · Accepted solution]

For ITEM_NAME column, try expression :  MaxString(ITEM_NAME)

[kulasekhar]

Hi Tresesco,

For ITEM_NAME column, try expression :  MaxString(ITEM_NAME)

For SPECIFICATION_NUMBER also same expression work or not.

Thanks a lot

sekhar

[avinashelite]

It works try like this

MaxString(SPECIFICATION_NUMBER )

[#6]

Use a straight table?

[kulasekhar]

Thanks Avinash

[kulasekhar]

Hi Avinash,

For DATE field how can sort like min or max.

Thanks

Sekhar

[avinashelite]

Sorting or you want the min or max?

if its sorting then go to chart properties and Sort >select feild > numeric > and select ASC/DESC

hope this helps you

[kulasekhar]

Hi Avinash,

I want the Minstring or Maxstring. Mine it's working Minstring in expression. But Maxstring it's not working.

Thanks

Sekhar.