Hiding particular row in table

[berryandcherry6]

I have table where one column row heading is made static with below code

MetricsDims:

LOAD * INLINE [ 

      Metrics 

Apple amount

Grapes amount

gross amount

total amount

];

for some table i need to show total amount and for some not.How could i do this .Please help me.

[sunny_talwar]

May be use the set analysis in your expression:

{<Metric -= {'total amount'}>}

or

{<Metric ={'*'} - {'total amount'}>}

Alternatively, you can use a calculated dimension:

If(Not Match(Metric, 'total amount'), Metric)

and then check 'Suppress When Value Is Null' on the dimension tab of the chart properties

[berryandcherry6]

Hi sunny,

Thanks for reply

in Expression ,i am using this, i am getting value ,

if(Metrics = 'total amount'',(((Sum(apple_amount)+sum(grapes_amount)))

but In front of this total amount i want to display $ 'Symbol'  .

Ex: total is 500.

i want to display it as $500 .

How could i do this.  Please help me.

[sunny_talwar · Accepted solution]

May be using the Num() function:

Num(If(Metrics = 'total amount'', (Sum(apple_amount) + Sum(grapes_amount))), '$ #,##0.00')

[berryandcherry6]

Hi Sunny

Thanks,You are my charm as always.:)