-
Re: Avoiding circular references with calculations on Previous List Item (Numbered List)
Ok, I've built it anyway to make sure everyone is helped out on this topic. Again would not say that this is best practice: First you need to create a time range just for this purpose. I've put it to…2 -
Re: Avoiding circular references with calculations on Previous List Item (Numbered List)
I would not suggest creating a combined hierarchy with time in it, I would rather combine the other lists if possible, but if you must then this might be a solution: 1 Create a time subset that inclu…2 -
Re: Returning Dimension/List Item based on Line Item
If you are sure that there is only one result per region, then Anirudh's method with FIRSTNONBLANK should perform better I think.2 -
Re: Days in Month
Hi Chris, In general I like your reply, I usually jump into the complex formulas to fix a simple issue if there is no other functional way to do it. Your solution has limited size implications, proba…1 -
Re: group by line item
Hi AshaPatil, You probably want to create a list (lets call it "List A") based on the text line item A and change the dimension of module 1 to List A. Then change the format of line item A …1