Hide total in Pivot but Indent mode

[Anonymous]

Hi All

Is there any way to hide total in Pivot with indent mode? Please note The partial sum option is already unchecked. Tried Dimensionality() also.

Your suggestion is highly appreciated. Thanks

[mohamed_ahid]

HI

can you send a sample file plz?

[Anonymous]

Hi Mohamed

In QV I do not want total against year.

Thanks for your effort.

[Gysbert_Wassenaar]

The dimensionality function works for me. See attached qvw.

[Anonymous]

Hi Gysbert

This is nice example, but still it shows - (null). I want to leave whole line empty. With 'Populate Missing Cell' as space; I am losing required blank lines from report also.

Is there any way please?

[Anonymous]

Hi Gysbert

I checked one more time, and your example helped and worked .

I can see blank line as per your example you sent. I appled the same

Thanks a lot, Thanks Mohamed

[vikramv]

The simplest way is to turn on the design grid.

Then right click on the Cell ,Click 'Custom Format Cell' and Change the Font and Back Ground Color to White()....

Regards,

Vikky.