Hi @Drushya You can find it using the below line items.
Let me know if this helps out.
Try this:
MONTH(ITEM(Time)) = 1
@Drushya
@Dikshant nailed it, his is the best answer and will perform best because it has fewer calculations.
Done with the course but want to practice a bit more before I take the Level 1 exam
Has anyone tested Analyst’s response quality/speed on large, sparse models (think 10+ dimensions, millions of line items)? Wondering if there’s a practical ceiling before it starts timing out.
I have a question about the new Expand or collapse grid rows option. Is it possible to publish a grid containing a 5-level hierarchy so that all items from levels 1 and 2 are always visible? And I do not want to use a filter for this.