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