Report drilldown in different dimension

[Former Member]

Company hierarchy is split in to 3 regions.( A,B,C)

Under each regions there are 10 company each (approx).

Reprting requirement is such that on each region client wants to drilldown uniquely and see the data either by product, or functional area or business area.

For example, under A regions there is 10 company code. A is total sale is 10 million and customer wants to drilldown the detail and see the totsl specifically by business area.

Similarly B region total need to be drilldown only by functional area and the total composition seen only by this.

Similarly C region product details.

How to achieve this navigational drill thru data modeling or what will help this.

Any clarification appreciated?

[Former Member · Accepted solution]

Hi

You can give the by product, or functional area or business area as free charecteistics.Region in Rows and sales in column. In the key figure properties, tick mark constant selection

This constant selection in the key figure properties will make the total of the region will be constant and it will split accordingly to your drilldown

Regards

N Ganesh