Straight table Total value issue

[mayankraoka]

Hi All,

I have straight table having 2 dimensions and 1 metrics.I am showing the total value as well.I want the total value will be displayed only when all the rows have value if any table value is not there(NA),It should not show total value.

Attached Image.In this image whenever NA is there total should not be displayed.

Can anyone help me on this.

Regards,

Mayank

[settu_periasamy]

Can you this this one?

=if(Dimensionality() =0 or Dimensionality()=1,
if((Wildmatch(concat(distinct aggr(
IF(CT='IND PHA',if(Count(DISTINCT CM)>2  and max(OTLT_CNT)>3,Sum( {<CM=>}sales),'NA'),
if(Count(DISTINCT CM)>2 and Count(DISTINCT ENTERPRISE)>1 and max(OTLT_CNT)>2,Sum( {<CM=>}sales),'NA')),ST_CD,BG),'|'),'*NA*'))>0,'NA'),
IF(CT='IND PHA',if(Count(DISTINCT CM)>2  and max(OTLT_CNT)>3,Sum( {<CM=>}sales),'NA'),
if(Count(DISTINCT CM)>2 and Count(DISTINCT ENTERPRISE)>1 and max(OTLT_CNT)>2,Sum( {<CM=>}sales),'NA')))

[mayankraoka]

Hi Sethu,

I tried this also,It is also not working.

Regards,

Mayank

[mayankraoka]

Any help on this is highly appreciated?

Regards,

Mayank

[mayankraoka]

Experts,

This is urgent requirement.Can anyone help me on this?

Regards,

Mayank

[mayankraoka]

Hi All,

Thank you very much for your inputs .I got the solution for above question.

Regards,

Mayank