Restricting data with few fields and grand total visible

[rsdhavle]

We have restricted data using lock field option however we want so show grand total for comparison corresponding to client field. Is ther any way to handle this?

[Gysbert_Wassenaar · Accepted solution]

Use a set analysis expression that calculates the grand total: sum({<MyLockedField=>} Value). The {<MyLockedField=>} part makes the expression ignore selections in the field MyLockedField.

[rsdhavle]

will this work if we are locking the field while opening a document?

[Gysbert_Wassenaar]

Yes