How to hide total from Pivot table

[#1]

Please find the attached my requirement. In Pivot table I just wanted to hide Total of all rows except first one.

Not able to do that , please help.

Message was edited by: Vishal Patil

[surendraj]

Properties-->Expressions-->

select the expression-->Total mode-->enable..No totals.

[#3]

I want Sum of first record i.e Cash  and for rest I dont want.

I am using Pivot table.

[surendraj]

Use the set expression in expressions tab

Sum({<level1={'Cash'}>}Market Value)

Note:Here i consider Level1 as afield name and Cash as field value.

[#5]

With this I am not able to display records from 2nd record onwards.

You can use below data for the same.

Data:

LOAD * INLINE [

  Level1, Level2, Market Value

  Cash, Investment Cash, 100

  Cash, Deposits, 200

  Fixed Income, Other Fixed Income, 500

  Equities, US SMID Cap Equities,900];

[surendraj]

Do you want this..

[#7]

Hi Surendra ,

I need below result.

[vinieme12]

can you provide in excel format?

[Anonymous]

Please check the attachment.

[#10]

Please note that the option "Always Fully Expanded" will always on , so if I expand it I will not see the desired result.