Hi All,
I'm a beginner. I'm trying to create a new table view report in OBIEE which shows sales related data.
I have Manager name, region, type of customer, Rank (logical column) and revenue under columns & measures. So the table looks like
| Region | Manager | Rank | Type | Revenue |
|---|
| Region 1 | ASM | 45 | Target | 220,000 |
| 35 | New | 300,000 |
| 45 | Total | 520,000 |
But, I need to merge the Rank column and display as one value (only target's value) like below.
| Region | Manager | Rank | Type | Revenue |
|---|
| Region 1 | ASM | 45 | Target | 220,000 |
| New | 300,000 |
| Total | 520,000 |
Could anyone guide me please?
Thanks in advance