Limit fields in dimension

[#1]

Hello all,

Within my data set, I have some groupings that are sub totals, is there a way to remove these from showing in some charts?

For example, I have a list including Sub Total and Total in a group, can I create a calculated field that removes those two?

With thanks,

Simon

[kaushiknsolanki]

Hi,

     You can use the calculated dimension such as

     if(Field <> 'Total',Field)

Regards,

Kaushik Solanki

[#3]

Hi Kaushik,

I've given that a try, but it seems to have removed the name from the axis, but included the data under "-".

Any idea why?

[#4]

Got it, I suppressed the null values.

How can I put multiple in there? Such as Total and Subtotal?

[kaushiknsolanki · Accepted solution]

Try this,

if(not wildmatch(Field,'Total','Sub total'),Field)

Regards,

Kaushik Solanki

[#6]

Magical. Thank you for your help