-
Re: Counting Headcounts of Male Fulltime Employees Using IFTHEN Formula
Hello @agk729 , Yes exactly, create a new line item & put the formula in this one. The 1 in your formula will act as the count.1 -
Re: Counting Headcounts of Male Fulltime Employees Using IFTHEN Formula
Hi @agk729 , If you're going for approach 1/2 use name(gender)="Male" and same for the other line item as we need to convert the list format to a text format first. I also suggest usin…1 -
Re: Column Customization
Hi @ArthurA , Is your item list a property/mapping for the general list? If yes, you can add 2 grids side by side & turn on the synchronised scroll (vertical) to achieve the above outcome in the …1 -
Re: Get previous Item in current list
Hi @ArthurA , You cannot create recursive calculations with a non-time list. The easiest way to go across this would be to map your custom list of Week 1 to Week 52 to a native time list & do the…1 -
Re: sort functionality for nested dimensions
Hi @Himaniam , You can achieve the same result without having to pivot the table & then use the native sort functionality. Keep the dimension in page selector & apply a filter to that. Ideall…1

