Thursday, August 6, 2015

Sorting based on user selected column - Dynamic sorting by prompt selection

Dynamic sorting by prompt selection

=====================================

> drag two cols like country and revenue

> drag value prompt to prompt page

> Static choice country and revenue used value and display value

> Drag one query expression mean create new cols in list

> case

when paramdisplayvalue='country' then 'contry'

when paramdisplayvalue='revenue' then 'revenue'

else end

> select that particular col country / revenue then grouping/sorting keep that cols

> select another col grouping and soring keep that cols
> remove sort that cols from list