Not able to format data within a table

[Anonymous]

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

[Anonymous · Accepted solution]

@Tan  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. 

[Tan]

you may not be able to edit in Report Tab if you go in Modeling tab (edit queries) you will be able to

[Anonymous · Accepted solution]

@Tan  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. 

[Tan · Accepted solution]

I would suggest creating a measure using count() and than use the modeling Tab

COUNT_Emp_id = COUNT('Table'(Emp_ID))

[Anonymous]

Thanks @Tan it worked.