HI all,
I have Qty ,added qty and gross qty( key figures) in rows and posting periods in columns.
Iam getting Qty for all the periods.But for the added qty it should compare period to period and the value should get displayed in the operand period.
Ex: period1 period2 period3
Qty 1 2 3
Added Qty 1 1
here added qty for period 2 is 1 which gets displayed under 2.
I have taken 2 restricted key figures one with period 1 and Qty and the other with period 2 and qty
I created one Calculated key figure as RKF2-RKF1 and taken that CKF into the report hiding the RKF's.
When I execute the report in the row added qty the both qty values are getting dislayed and the exact value 1 is showing in overall result.
period 1 period 2 overall result
EX: Added qty 1 2 1
how to get the exact value 1 in the period 2 column for added qty which showing in overall result?
Will cell editor workout in this type of situation? if yes then plz explain in detail how to use cell editor in a report ?
Please answer
Thanks