Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.
Kimball Forum

Discussion Group for the Dimensional Data Warehouse and Business Intelligence Community


Sorting issue

2 posters

Kimball Forum :: Topics :: BI and Analytics

Go down

Sorting issue Empty Sorting issue

Post  Bari Mon Jul 18, 2011 9:01 am

hello

I have list report and have a column Category which has "New Store" and "Old Store”. This report is mainly developed through

Sql Query. The Problem is when i drag Category column it comes as New Store and Old Store where as the requirement is that it

Old stores should come first. What i did is I dragged a data item and wrote expression if([sql][Category]= 'Same Store') then (1) else (2)

and then cut the column from report page and sorted category as descending, it did the trick and met the requirement. My question is when i am sorting as ascending it is same old thing where as ascending should have worked. I am confused, what is going on here. Could gurus please explain. Thanks.

Bari

Posts : 2
Join date : 2011-05-12

Back to top Go down

Sorting issue Empty Re: Sorting issue

Post  VHF Mon Jul 18, 2011 11:13 am

What database platform and reporting tool are you using?

VHF

Posts : 236
Join date : 2009-04-28
Location : Wisconsin, US

Back to top Go down

Back to top

- Similar topics

Kimball Forum :: Topics :: BI and Analytics

 
Permissions in this forum:
You cannot reply to topics in this forum