The formula which I'm using to Identify Quadrants: (It will work properly if we have a single period)
Is there any option to fix that formula on period="YTD_CY"
Screenshot for reference :
In an ideal scenario the Blank SKUs in YTD_CY column, They shouldn't be there.
Please let me your thoughts regarding the same.
Hello Darshan ,
Do you want to exclude all the SKUs that do not have a corresponding YTD_CY value?
Drag YTD_CY to the filter shelf and filter out nulls in the worksheet. This should leave only SKUs with a YTD_CY.
Forgive me if I am misunderstanding the requirement.