Question about Boolean line items

Scenario

My rows include 3 items - REC1, REC2, and REC3

my columns include quarters - Q1FY25, Q2FY25, Q3FY25 and Q3FY25

Line item - 'Select' which is formatted as Boolean.

Desired Output - If I check any one Boolean among REC1, REC2 and REC3 for a particular quarter, the remaining two rows should automatically be disabled.

How can I achieve this result?

Accepted answers

devrathahuja

Hi @31MB ,
You can add a DCA to the line item.

Similar example below-

When I have REC2 selected, other 2 are disabled.

DCA R is set to true
DCA W line item -

This ensures if nothing is selected then all the lines are open, if something is selected only that is enabled to be deselected.

Hope this helps! :)

All comments

devrathahuja

Hi @31MB ,
You can add a DCA to the line item.

Similar example below-

When I have REC2 selected, other 2 are disabled.

DCA R is set to true
DCA W line item -

This ensures if nothing is selected then all the lines are open, if something is selected only that is enabled to be deselected.

Hope this helps! :)

MayurBodade

@devrathahuja we have to keep the summary for line item Select to ANY, right?

devrathahuja

@31MB - Yes

Quick Links

Can you help?

Unanswered questions

UX Filter
Hi ALL, I have a module where a line item (Assignments column) is formatted by a large ‘Projects’ list. Each record is assigned to a Project and this module is published to a UX page. When users apply a filter on the Assignments column, the filter dropdown displays the entire Projects list (since the column is…
Dimensionality Issue
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
Formula to return Connection details...
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?