Pivot format

[Anonymous]

Hi,

I have done a pivot table in a particular format, but when I choose a some selection the format of the table is getting changed.I have attached a screen shot.

I have enabled the option of "Show all values" and Disabled the option of "Suppress zero values".But its changing..My expectation is that  even if I select something, it shouldn't change. Could anyone please help me out.

[prieper]

Please post an example

[vinieme12]

Modify you expression to ignore selections in fields

2 ways to do that

1) for Example, specify the fields to ignore

Count(   {<     Target=, field2=,  ....   >}   YourField)

Here selections on fields Target and Field2 will be ignored

2) ignore all selections

Count({1}   YourField)

[tajmohamed30]

increasing font size may help as I can see the line over the top disappears