ContributionsMost RecentMost LikesSolutionsRe: Counting of Rows on Same ValuesHi Paul, Thank you for the query. Now it shows me the count of same rows as 1, 2 and so on which is much better than what it was showing with my query as 2 and 2 on both the rows. I would now like to have the higher count rows added to another table. Would that be possible thru a pipeline where it can check the Max Record id and push that record into the new table? Not sure how to go about it. Regards Gunsham ------------------------------ Gunsham Lakhiani ------------------------------ Re: Counting of Rows on Same ValuesHi Mark, I do not want any manual intervention but it should be automated thru pipelines or any other way. Thanx ------------------------------ Gunsham Lakhiani ------------------------------ Re: Counting of Rows on Same ValuesHi Mark, My problem is not a Summary Report or enough Group Bys. What i want to do is I would like to have a Count only on the one row for which the combination is the same and then i would like to insert those rows in another table. For example if you have a look at the screen shot on the Top Grid QB Output you would see that Gunsham Lakhiani-14-Green shows Total Count 2 in both the rows but I want the Total Count 2 in any one row and then would like to add that in another table as below Name Week Color Count Gunsham Lakhiani 14 Green 2 I hope i am able to explain what i am trying to achieve. Looking forward to hear from you. Regards Gunsham ------------------------------ Gunsham Lakhiani ------------------------------ Counting of Rows on Same ValuesHi, I have 2 tables Employee and Task. Each Employee has many Tasks and those Tasks are defined weekly. In the Task Table I am trying to capture the count of the tasks by Employee Name+Week Number+Colour. So if an Employee has multiple tasks which results in the example like below. Row 1 Gunsham Lakhiani-14-Green Row 2 Gunsham Lakhiani-14-Green This should be counted as 2 which is what i am trying to achieve by adding a column of Total Count which results in to 2 in each row. I would like to have the count 2 only in one row and not in the second row after which I want to just dump Employee Name,Color,Week Number and Total Count into some other table where the Total Count is not blank for certain calculations. Pl check the excel attachment or the Image below for your reference with the QB Ouput and the Desired Output. Regards Gunsham 9821258653 ------------------------------ Gunsham Lakhiani ------------------------------ Re: Formula Field-Multi Select TextHi Blake, If that is the case then what will be use of this Multi Select Field and where and how it can be used? Regards Gunsham ------------------------------ Gunsham Lakhiani ------------------------------ Formula Field-Multi Select TextHi, I have created a formula field which is of type multi select text. The formula is working fine but when i am selecting this field in the report selection as ask the user it shows as a plain text box and does not show as a multi select drop down to select the options. Below is the formula which i have used in this field Split(List(" ; ", If( = true,"A"), If ( = false, "B"), If ([ROption] = "A","Yes") )) Can anyone help to find out why it does not display as a drop down? Regards Gunsham ------------------------------ Gunsham Lakhiani ------------------------------ Re: Related To ReportsHi Austin, Yes, your understanding is correct but i do not know how to embed the site and how to create a button. For the button will it work with the Widgets Button on the Customise Page? Regards Gunsham ------------------------------ Gunsham Lakhiani ------------------------------ Re: Related To ReportsHi Mark, Point No 1 I don't need one single record, what i am trying to say here is that I would like to have one option to be set as default out of the multiple options available in the ask the user and if i need to change i should be able to select the desired one. Point No 2-Example a. I have a field called Type as Multichoice which has 2 options A and B b. I have another field called Name. I create one record with Type as A and Name as ABC I created second record with Type as B and Name as XYZ Now when i create a report with Type and Name both as Ask the user. So when i select Type as A the Name should get filtered on the basis of Type A which is not happening as it shows ABC and XYZ both in the drop down where as it should show ABC only which is of Type A I hope with the above example you will have more clarity as to what i am looking for. Regards Gunsham Regards Gunsham ------------------------------ Gunsham Lakhiani ------------------------------ Re: Create a Dropdown from a Formula FieldHi Mark, Sorry but i could not get what you are trying to say. The formula field Year is in the same table where the data is created so how does relationship come in the picture. I just need a list of the years which keep getting generated thru the formula where i should be able to select either one or multi. Regards Gunsham ------------------------------ Gunsham Lakhiani ------------------------------ Re: Create a Dropdown from a Formula FieldHi Mark, Thanx. I have already done what you are suggesting but would like to have it as a selection. Is there no way to do this? Regards Gunsham ------------------------------ Gunsham Lakhiani ------------------------------