Skip to Content
0
Former Member
Aug 08, 2007 at 10:01 AM

Use result row in exception reporting

8 Views

Dear All,

Need your expert advice here.

We have a reporting requirement to show account balances in a cross tab report (for 30 calendar days) as below:

Calendar Day

Account 01.01.2007 02.01.07 03.01.07 04.01.07 .....Avg Bal(Last 30 days)

AC1

AC2

AC3

.

.

User also wants to see the average balances of each account and create exception if any days Balance is less than "x %" of Average balance.

We have been able to create the cross tab report But we are not sure how to meet above requirement.

If i define a calculated Key figure as %CT of Book Balance, the output is shown as "X" and it gets displayed on all calendar days which is not required.

alternately if i set "Average of all Values" on on Balance key figure and do not suppress results for Calendar day(which i have put in columns), i can see the average balance, but i don't know how to use this in exception definition.

Please help!!

Regards

Rakesh