Hi Experts,
please find the attached file
I have one requirement my data is like
| Desc | Country | Revenue | Adjust |
| AB | IND | 0 | 100 |
| BC | IND | 200 | 0 |
| CA | IND | 300 | 950 |
| DE | PAK | 0 | 450 |
| EF | PAK | 500 | 550 |
| FG | PAK | 600 | 0 |
| LM | SL | 0 | 250 |
| MN | SL | 800 | 0 |
| OP | SL | 900 | 150 |
Here total revenue is (3300) and total Adjust is(2450)
i have created one straight table and
Dim:- Desc
Exp:-Sum(Revenue) like below
| Desc | Revenue |
| 3300 |
| BC | 200 |
| CA | 300 |
| EF | 500 |
| FG | 600 |
| MN | 800 |
| OP | 900 |
in this straight table i have to add one row in this table it is TOTALADJUSR in Dimension column and sum(Adjust) in Expression row.
how can i achieve this.
Final out put table is
| Desc | Revenue |
| 3300 |
| BC | 200 |
| CA | 300 |
| EF | 500 |
| FG | 600 |
| MN | 800 |
| OP | 900 |
| Totaladjust | 2450 |
Regards
mahesh
