I have a report which is built off an infoset,
When I view the data in the infoset I see the following data
Doc Num Key Figure1
In the report the key Figure1 is shown as 100
I have tried to model the same on a cube where Key Figure1 and in the report my Key Figure1 is shown as 400. How can I get it to be 100 as in the info set?
Please provide the complete output because the values which you are displaying cannot be possbile until there is some unique characterstic as i see you have same document number for which in report it may display 400.
Find out the unique characterstic on which you are drill dowing further and based on that you are getting repititive values.
Provide me the complete layout of the report then i will provide you the solution if it wil be techincally feasible.
Hope it helps.