Ranking and Date dimensions
Hello everyone,
I am trying to sort some values descending in order with addtional time dimensions so i can prompt them on my dashboard.
I can get it to rank correctly when I omit the Date fields (Year,Qtr,Month) however, if these are present then i get the ranking based on smaller values due to the dates because OBIEE is breaking it down to the month
which have different costs associated to that date.
Example:
Field1 | Value(desc) | Rank
1001 $3,654 1
1400 $1,520 2
3501 $1,511 3
3508 $1,200 4
1601 $958 5
1401 $608 6
1602 $200 7
So when Month is present for example, my amount is not 3,654 but rather 2 rows that sum up to 3,654. I do not want that to happen, but i still want to have the fields so i can filter.
Field1 | Value(desc) | Rank | Month
1001 $1,830 1 Jan-2009
1001 $1,824 2 Feb-2009
Does anyone know how to display as the first table with the additional Date fields on affecting the row result?