Hi,Iam using a straight table , and i need to show only sub-totals in '%' for your reference please go thorough the images below.

[nareshthavidishetty]

[sunny_talwar]

You can use the concept of Dimensionality() to do this. Look at the following Blog by Robert Mika: How to use - Dimensionality()

[engishfaque]

Dear Naresh,

Expression1: Total Sales % = Sum(SalesField) / Sum(TOTAL SalesField)

Expression2: % Sales by Country = Sum(SalesField) / Sum(TOTAL<Country_Field> SalesField)

Kind regards,

Ishfaque Ahmed

[nareshthavidishetty]

Hi,

My sales field contains expression

Closing Rate=[invoice count]/[Adjusted Tariff]

Can you please help me how to write the expression.

[sunny_talwar]

Not sure, but may be this:

If(Dimensionality() = 0, Num([invoice count]/[Adjusted Tariff], '#,##0.0%'), Num([invoice count]/[Adjusted Tariff], '#,##0'))

[nareshthavidishetty]

Hi,

It is not working,it gives me same output.

[settu_periasamy]

Hi Naresh,

Did you try with sunindia Expression With the Total Mode as Expression Total ?

[sunny_talwar]

I think you mean formatting as Expression's default, right?

[settu_periasamy]

This One

[sunny_talwar]

I guess we need both to be Expression default