Hide a single expressions sub-total.

[NickHoff]

Hello,

I have a metric that is giving the Max(FieldName).  The subtotal for a dimension provides no value and is causing confusion.  However the subtotal needs to exist for the other metrics.  How can I hide the sub-total shown below:

I'm able to hide the grand total using the option No Totals as shown below, but the facility sub-total shows:

[mayankraoka]

Hi Nick,

Please see below option to play with subtotal:

if you mean to subtotals in Pivot chart, you can use RowNo() function to determine if it's a total row. In subtotals it's always 0 (except the entire-chart total).

For example, insert this syntax in the expression of the chart:

if(RowNo()=0,'Subtotal','row-data')

This is what you'll get:

Regards,

Mayank

[mayankraoka]

Another option go to presentation if this is pivot table. Uncheck show partial sum option .

Regards,

Mayank

[NickHoff · Accepted solution]

Hi Mayank, the table is a straight table.  I have to use a straight table for my problem because the totals don't add up correctly based on my expression.  I spoke with a co-worker about the problem and it turns out I could use If(dimensionality = 1, Null(), Expression)