Query is built on a Infocube which has data at a profit centre and sales document level.The query is used to calculate the revaluation based on the conversion factor.
user needs the report at the profit centre level.
The query is created with profit centre in the Rows and the amount KF(always in USD) in the columns.
created a formula variable with replacement path for the doc date which is a display attr of sales document.Currency conv is done on the KF to convert USD to document currency.
The query is displaying results at a profit centre & document level..when i remove the sales doc from drill down the results are displayed as 'x'.
pl suggest