I have requirement and I need to know how to do it in the query designer.
I have two key figures called deferred revenue and revenue recognized. If the deferred revenue KF is not initial then I have to display the fiscal period under the deferred period and if the revenue recognized amount is not initial then display the fiscal period under the revenue recognized period.
cocode Bus area Profit center def period revenue period defered amount rev recognized amount
100 1000 2000 001/2010 1000.00 0.00
100 2000 n 2500 002/2010 0.00 5000.00
The fiscal period has to be dislayed like the above based on the the 2 KF values.
Thanks for your help in advance.