My infocube has the information as given below:SITE MATERIAL DATE BILL.NUM KEYFIG(No.of Billing Docs) S1 M1 5/9/2012 B1 1 S1 M2 5/9/2012 B1 1 S1 M3 5/9/2012 B1 1 S1 M3 5/9/2012 B1 1
Now, I am designing a Query, where I am using No.of Billing Docs Key figure. In the report, I am expecting to see No.of Billing Docs as 1 for site S1(because our query is at site level).
So for the site S1, on Date 5/9/2012, I expect No.of Billing Docs in report as "1".
But the actual report shows as 4 (which is a summation).
My Question is: Please advise me on how to define the No.of Billing Docs Key figure in the Query to get my expected value ?
Appreciate your help.
Thanks and Regards,