Hello Experts,
I have a problem with my reports.
The probelm starts with compounding of InfoObject <b>Item</b> with <b>Verson</b>.
Ths scenario is as follows.
We have an ODS which stores the financial data.
We have Item and version as part of ODS key. We store amount for each Item depending on version. There are 2 versions. European Version and US Version depending on various tax rules. The amount in case of European version is stored as full value and the amount in case of US version is stored as delta value. We are supposed to calsulate US full value as sum of European full value and US delta value.
Now
I have a report which fetches European Full vaue in 1st column and US Delta value in 2nd column. and a 3rd column with a formula to calculate the sum.
The data in ODS look like this.
Item Version Amount
1001 EU 1500
1001 US 200
The above report looks like this
<b>Item___EU Full_____US Delta____US Full</b>.
EU/1001____1500_____0_____1500
US/1001_____0_____200_____200
as the infoobject Item is compunded with version.
But i want to show like this.
<b>Item____EU Full____US Delta____US Full</b>
1001_____1500_____200_____1700
How can I get rid of this compounding in the report.
Message was edited by: Suneetha
Message was edited by: Suneetha
Message was edited by: Suneetha