Hide Dynamically datas in a matrix
Hello Everyone, yes i've already posted yesterday about a similar problem but did explain i think i oversimplified my problem and it resulted in helpful people answering beautifully my question but it did not solve my problem To explain my problem i'm working on a Dashboard that displays interesting numbers about education. I'm working with several filters and the data is quite sensible. I want to be able to put what we call in France the "Statistic Secret" to prevent anyone to find specifically people that succeeded/ or not, at their diploma. The usual way is to mask any data that could lead someone to identify 5 people or less. So that is what i want to do and here is the matrix i want to apply it on. As you see it is a matrix with 2 levels, "GFE" and "Title of diploma", i will call them Group and SubGroup. For the two integer(not the %) columns that i will name columnA and columnB that is what i want to do: -If there is one value <5 in column A or B, mask both value (so the value <5 cannot be calculated via the %) -If there is only one subGroup in a Group that has his values masked. Mask another SubGroup values in the Group (so it cannot be calculated via the subtotal of the Group) -if there is only one Group that has his values masked, mask another Group values (So the initial Group values cannot be calculated with the total) and all of his SubGroup values (So the second Group masked cannot be reconstituted) On this example all the datas are in the same table but i have other pages of the Dashboard where there are matrixes that joins multiple tables like diplomas name are on a different table than the values I'm very thankful if someone can solve this problem as it is tearing myself up ! Have a nice day
