Forum Discussion
Not able to format data within a table
Hi,
I am not able format my table data. I want to add a comma seperator and dollar sign to the numbers. However, the format option under modelling tab is grayed out.
Thanks,
HV
- Anonymous6 years ago
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.
- Anonymous6 years ago
I would suggest creating a measure using count() and than use the modeling Tab
COUNT_Emp_id = COUNT('Table'(Emp_ID))
4 Replies
- AnonymousNot applicable
you may not be able to edit in Report Tab if you go in Modeling tab (edit queries) you will be able to
- AnonymousNot applicable
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.
- AnonymousNot applicable
I would suggest creating a measure using count() and than use the modeling Tab
COUNT_Emp_id = COUNT('Table'(Emp_ID))