Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Please post an example
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)
increasing font size may help as I can see the line over the top disappears