Skip to Content
0
Former Member
Dec 05, 2008 at 02:43 PM

Problem with Drill Function

18 Views

Hi

In our Report we have a table inside a section.The section label is Department so if i apply drill it goes to 3 levels down like Category, Sub Category and Product level. The Drill is working fine for this.But we i placed a cell next to the section with a Sales Total(measure) object then the Drill is not working on the new cell.I tried to put in a table both section name and sales total but still Drill is not working for sales total.

When i search in the forum i found the below syntax which is useful for me.

Quote:

you create an object and place this in the object "=if ([Level Number] = 1; [L1]; if ([Level Number] = 2; [L2]; if ([Level Number] = 3; [L3]; if ([Level Number] = 4; [L4]))))"

Can anyone help me how to create a variable with the above formula as per my requirement.

Thanks

Ravi