Sum and Count in summary column

[#1]

Dear All,

               Please find the attached documents , i need the output as mentioned in sheet2, with sum and count values in summary row for all expressions.

I trired with dimensionality function it works for me for one expression others does not.

Regards,

Ravi.

[Sokkorn]

Hi Ravi,

In your attached file don't have sheet2, so please attache file again or reply me back what you want.

Regards,

Sokkorn

[#3]

Hi Sokkorn,

                    Thanks for your quick reply but i got the solution with dimensionality function().

Regards,

Ravi.

[Sokkorn]

Hey Ravi,

Let me cheer with you .

Regards,

Sokkorn

[#5]

Hi Sokkorn,

                 For your reference, please have a look into below script.

=if(dimensionality()=0,sum(sales)& '/  ' & Count(Distinct pono),sum(sales))

Regards,

Ravi.