Hello there,
I am having a hard time finding a way to solve this and I will appreciate your help.
in the attached dummy file I would like to create a calculated field to be used as a filter to exclude the customers that didn't generate revenue in one of the year and include only those who generated values during all years.
5 answers
Hi @Mona Samir, here is a solution with table calc. The LOD might fail once you start dragging other dimensions in view but LOD is the best option if that is what your table is made up of.
Create a calc. as shown below
SIZE() = WINDOW_COUNT(min(YEAR([Date])))
Drag this row to compute table calc. , then put this in the filter and check true.
Workbook attached for ref. I hope this helps.
