Validation on horizontal Checkboxes

Question

Hello

I had to apply a validation rule on a cube (checkbox) to ensure only one choice is selected. However i need to enable the ROWTOTALS for it to work (and the validation only works when save/undo is enabled)

Is there any way for me to lock the column totals. I cannot hide it otherwise the validation rule does not work.

PS: Im trying as far as possible not to go through additional cubes/procedures

thank you

Robert Barkaway · Answer

Good to hear you got it working, sorry I didn't get a chance to reply earlier!

Khaleelah · Answer

Hello,

Found the issue.

I needed to add a detailby  on the lock algorithm since the block using the lock has a detailed by .

Now it is working.

Thanks a lot.

Rgds

Khaleelah

Khaleelah · Answer

hello

Below is the layout

Then i added the cells locked by Block, which raised the issue.

Thanks

Khaleelah