Forum Discussion
How to Get Your Question Answered Quickly
Hi there, I am creating a matrix of data with 3 levels and only the bottom level has values in and the 1st and 2nd are just for orgsanising them. I looking for a way of stopping the top and 2nd level from creating a made up value which is some sort of summary of the lower levels reponses. The value dissapears when drilling down to the lower level which is how I would want it. I have ticked which rows are drilled down and correct and also crossed the ones I am trying to fix.
For example on the bottom row, there isn't any data that aligns with suggesting the results of No,no,no,no,no,Complete,Complete,Transofrmation etc, however in the lower levels there is data there and it seems to be summarising that and providing a value at the top.
Anyone know a way of sorting this or just only getting the data to show at the bottom level?