I'm stuck on a few problems but I think they can all be traced to no knowing/understanding how to work out what proportion a particular value is of a whole. For example, if I have various statuses (say 'compliant' and 'non-compliant') for a range of project criteria, how can I work out what proportion is 'compliant' or 'non-compliant'.
I've successfully used table calculations when the view is showing the same quantity, but when I try and write a calculation (using LOD functions) for my self-defined quantity I get an error saying that I can divide/multiply fields at different levels of detail.
Can anyone help?
Can you attach a workbook with Superstore data?