I have a SP2010 list.This list has a choice column.
I want to create a view with the unique items(latest one) from this column.
How to achieve this?
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.Sign up to join this community
I displayed the list in DVWP and replaced the "Rows" variable in "dvt_1" xsl template section using the below XSLT:
xsl:variable name="Rows" select="/dsQueryResponse/Rows/Row[not(@Columnname=following::Row/@Columnname)]"/>
This helped me to display the unique values from the choice column and i used sorting to display the items as i required.