How to filter based values based on calculated measure
I have created a STATUS field in a report based on the comparison of sale of month selected and previous month of selected month.
if selected month sale is less than 50% of previous month sale than the STATUS is shown as 'Non Supporter' else 'Supporter' which is working fine.
But now i need to use this STATUS field as a filter in other reports as well. Means i want a sum only Non Supporter Clients in selected month or a list of Clients who are Non Supporter in the selected month.
I want to use this STATUS field in a filter pan so that i can use it in any sheet.