I want to use a filter year ok. The year will be extracted from GL_DATE and when I select 2021 it should match with year of the Ordered date which I have already taken out in the order lines table. The gl_date is in the invoice table. The only common relation between both is Order Number. I want to use this in a KPI. I tried using these but it gives me zero
Count({<GL_YEAR = {"$(=only(Ordered_year))"}, FLOW_STATUS_CODE = {'AWAITING_SHIPPING'}>} FLOW_STATUS_CODE)
//Count({<GL_YEAR = {"$(=only({<Ordered_year = {"*"}>} Ordered_year)))"}, FLOW_STATUS_CODE = {'AWAITING_SHIPPING'}>} FLOW_STATUS_CODE)
Can anyone fix it where I went wrong or make a code to fix my issue I saw the master calendar and canonical date but dk how to make the code for it as people are doing on same table. I have two table which have different dates and I want to do analysis based on there year and the common between them is order number. I want to use gl year as my filter but want it to match with order year once 2021 is selected from gl_year.
