Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a bar chart with dimension as Weeks and two expressions sum(qty) and sum(sales).
I would like it to sort in order like always most recent weeks(FW 31,FW 30,FW 29......) on top in barchart .
I want to sort the dimensions in the following order:
FW31---always current week on top.
FW30
FW29
is there any way I can do this custom sorting.
Thanks
go to sort tab of the chart properties and select dimension and sort by the following expression , Descending order
=only({1}keepchar(Weeks,'0123456789'))
or
=only({1}Purgechar(Weeks,'FW'))
go to sort tab of the chart properties and select dimension and sort by the following expression , Descending order
=only({1}keepchar(Weeks,'0123456789'))
or
=only({1}Purgechar(Weeks,'FW'))
Try in Sort Tab, set Text Z-> A
Hi,
Try this,
In the Sort tab,
Uncheck the state, and Text as Z-> A
Thanks your reply ,your solutions works if we want to sort the weeks ascending and descending order.
But I am looking for current weeks on top like below order.
Sort this from most current FW to oldest.
Most recernt FW to oldest FW...
Example:
FW31
FW30
is there any way I can do this custom sorting.
Thanks
is there any way how we can achieve this custom sorting.
Sort this from most current FW to oldest.
Most recernt FW to oldest FW...
Example:
FW31
FW30
Hi Rajesh,
Can you post the sample qvw?
i guess whatever i suggested for most current weeks only,
can you post the sample ?
thank u your solution is works fine.. I missed some thing earlier.