how to use nested set analysis

[#1]

Hi,

I have a Scenario anyone can please help me.

when total of sales are to generated at region, Territory, account and BU level (Nested Set Analysis)

Many Thanks

[jharke]

Good afternoon Mahi,

Use something like this:

=sum ( { $ < Region={'abc'},Territory={'def'},account={'ghi'}, [BU level]={'jkl'} > } Sales)

See for more information: Set Analysis: syntaxes, examples

[sunny_talwar]

Not sure I understand your requirement, would you be able to elaborate?