How to show only total instead of all data?

[#1]

Hi,

I have a table with data as below

Dimension: Customer

Expression: Count(SalesItems)

How can I show only total visible instead of the breakdown by data. Please can anyone suggest me.

Thanks.

[#2]

Is there any other way instead of text object. I know it will possible with text object. but I would need to show instead of text object

[sasikanth]

Didnt get you can eloberate it

[#4]

Do you mean you want to show the total count of all SalesItems for all Customers?  Try Count(TOTAL SalesItems).

[#5]

could you give a little more information about what you'd like?  What exactly is the total you'd like to display?

[#6]

Hi Amelia,

Rather than text box u can get it with Straight table ...

PFA...

[er_mohit]

try either this

Count(total<Customer=>SalesItems)

or

Count(total {1} <Customer=>SalesItems)

[#8]

Thanks. When I am using this it is showing error in calculated condition. how can I set this? Please help?

[rwunderlich]

Just remove the Dimension from your Straight Table.

-Rob

http://masterssummit.com

http://robwunderlich.com