I want to be able to divide Field A(filtered by Date) by Field A(filtered by Code).
Field A filtered by date gives me 319 records, Field A futher filtered by Code, gives me 282 records of the original 319.
I need to work out the percentage e.g. 282/319 = 88%
How do I do this? I have tried measure, quick measure and column and are receiving a result of 1 or 100% - it is assuming the Field result is the same even though I have created two separate measures for the difference in filtering.