Lock Pivot table

[#1]

Dear community,

Attached herewith the sample, I have pivot table with InputSUM column which should be locked.

If i select either Detached or Read Only, i will not able to change the value in InputSUM column, so that is not a good idea.

How should i lock this table so that user is unable to filter or select any selection from this table while they still can edit data in the inputSUM column?

The purpose of asking this is because user might accidentally filter some selections by miss clicking some cells, when entering data in inputSUM column.

Original table:

Accidentally clicking 100 that make filter to that row: (undesirable)

Desirable result: (But Detached is not a good solution as mentioned above)

Thanks,

Chanel

[its_anandrjs]

You are doing correct if you make it read only then user not able to select any thing on the chart.

Thanks & Regards

[alexandros17]

I think you have to check both the boxes ...

[#4]

If I check both boxes then the inputSUM column is not working...

The best case is user can edit data at inputSUM column, but the default filter feature in table is "de-activated".

So that user wont accidentally filter when miss clicking some cells...

can we have such ideal case?

[#5]

Yupe, but as mentioned, Read Only will deactivated my InputSUM column where user is not able to edit data in that column.

[#6]

Can you please attach an example?

[PrashantSangle]

Hi,

Use Text Object.

Cover All the fields that you do not want to select by the user.

Make it transparent .

Regards,

PS

[its_anandrjs]

Use SET analysis in your Expression and Baypass the filters that you dont want user to select and chart will filter like

Count({<Channel=,Event=,UserID= >} UserID)

In this user not select Channel, Event and UserID

and use your inputSUM field as a Inputfield.

But after this you need table box

Hope this helps