one more update.even i shall remove / hide rank column but the records should be displayed as per grand total in ascending order.
1 person found this helpful
The way you've drawn your pivot you've got Rank as an attribute ... seems you aren't giving us the other dimension (time and ???)
I did no special moves here (Year, Sales Rep Name, Revenue and RANK(Revenue)) -- worked by clicking the up/down sorting arrows (the default sort was the Sales Rep Name vertically)
Thanks for input but I would need report as mentioned below in my comments not as Individual datewise , rather it would on dimension say BY Sales rep.
Hi Cesar ,
Thanks for that extensive screenshots. I have added the details as below as per requirement. The Grand Total column is not needed.
Measure Values Grand Total Rank(Revenue) Sales rep 11-Mar-16 12-Mar 13-Mar Revenue Quantity Revenue Quantity Revenue Quantity 2 Sam 1200 5 1000 10 2200 5 4400 1 Chander 1000 7 2000 7 1000 9 4000 3 Karthik 1500 6 1000 4 2500 13 5000
The Rank would be calculated on sum of all revenues for each representative and not by Date wise
Measure Values Rank(Revenue) Sales rep 11-Mar-16 12-Mar 13-Mar Revenue Quantity Revenue Quantity Revenue Quantity 1 Chander 1000 7 2000 7 1000 9 2 Sam 1200 5 1000 10 2200 5 3 Karthik 1500 6 1000 4 2500 13
You could create a measure sum( by "sales reps") this.measure helps you to do a rank after this( check the order by as my.response with.screenshot), and finally it you could hide your.column go into criteria tab.properties.column and mark the hidden.property.
Can you tell me how would I create measure sum(By sales Rep) . Also I could not see your lates screen shot. could you pls check and add
1. Go oracle bi answers.
2. Edit your "analysis" object.
3. Create.a.column, and put the.mouse over the column, edit your formula and write the.code sum( revenue by sales reps)
4. In the criteria tab, put the mouse over the column and you.coould.see.a.propertie order by, set up the order by to this.column
5. Again put the mouse.over the.column and click.on column property, there and mark.with check the hidden property.
This worked fine.Thanks a lot.