Drill Down in the Excel Planning views

[Former Member]

Hello Team,

We got a requirement that user wants to view the values at a Location Region basis (aggregated level) and can drill down to further detailed Location level (Individual locations that are mapped in that region)

Master data was configured appropriately.

But when we open the planning view at Location region level and double clicking on it, getting the below error "The Bottom level has been reached, can't expand to a lower level"

Am i missing anything here ?

Thanks

venkat

[lingaiahvanam · Accepted solution]

Hi Venkat,

Select Location Region only and remove Product and UOM load the planning view. Later drill down by attribute based on your requirement.

That message is bottom level is reached you can not drill down to another. You should select the planning view value and choose the drill down option.

Best Regards,

Lingaiah

[Former Member · Accepted solution]

Hello again boss

Followed as per suggestions. But still it didn't worked with one aggregated attribute i.e Location Region.

Do i need to configure this drill down functionality anywhere like in Analytics, where we specify the Drill down links between the charts ?

Thanks

venkat

[lingaiahvanam · Accepted solution]

Hi Venkat,

Can you select time dimension (Week, Month) in planning view and right click you will get drill down option by attribute.

Best Regards,

Lingaiah