=====================================
> 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