Forum Discussion
Not able to format data within a table
Anonymous I cannot use edit queries to format the data, since my table is actually aggregating the data i.e. for each employee, it is counting the number of times that employee has appeared in the dataset (Employee Name, COunt(Employee ID)). Since neither ID and Name are numbers, I cannot add comma seperator in the edit query tab.
I would suggest creating a measure using count() and than use the modeling Tab
COUNT_Emp_id = COUNT('Table'(Emp_ID))
you may not be able to edit in Report Tab if you go in Modeling tab (edit queries) you will be able to
Anonymous I cannot use edit queries to format the data, since my table is actually aggregating the data i.e. for each employee, it is counting the number of times that employee has appeared in the dataset (Employee Name, COunt(Employee ID)). Since neither ID and Name are numbers, I cannot add comma seperator in the edit query tab.
I would suggest creating a measure using count() and than use the modeling Tab
COUNT_Emp_id = COUNT('Table'(Emp_ID))
Thanks Anonymous it worked.