Field on a individual drill down level.

[#1]

Hi,

I have a drill down group where I can drill down from department to each individual product, I would like to be able to show the pack size just on the product level. I have done the following but the result looks rather messy, is there a simple way of achieving this ?

=[Product] & ' ' & [Pack]

Thanks,

Gavin.

[stephencredmond]

Does it look better like this?:

=[Product] & ' (' & [Pack] & ')'

Stephen

[#3]

Yes it does look better, although I was hopint to be able to insert a column for exporting to excell.

[johnw · Accepted solution]

If I understood the question, I can think of a couple of approaches.

First, you could have two charts, one with the Pack column, one without. Use a show condition that depends on the value selected for the drill down group, like getcurrentfield(MyGroup)='Product'. That might be nicest from a presentation point of view, but would require dual maintenance.

Second, have one chart with the Pack column, and use a condition in the expression to only return a value if you're at the Product level in the drill down group, like if(getcurrentfield(MyGroup)='Product',sum([Pack])).

[#5]

Thanks John,

Works fine.