Skip to Content
Former Member
Sep 10, 2009 at 11:21 AM

Problem while drill down



I have a query which is based on the sales and which has the following characteristics i.e drill down is based on Region,Area,Territory, customer and material wise sales..

Intially we have to show up to customer where as material would be a free characteristics and the sales value for this should be shown.

when i look at the region wise/area wise/territory wise result it is not equal to the sum of the all the customer values but it is showing some thing which is entirely differant. so as i keep removing the drill downs the value is getting changed.

i used the option USE STANDARD AGGREGATION - TOTAL - WITH RESPECT TO MATERIAL AND CALCUALTE RESULT AS - TOTAL... to get even the customer level value rite or otherwise even that shows a differant value.