Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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

  • Anonymous's avatar
    Anonymous
    6 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. 

  • Anonymous's avatar
    Anonymous
    6 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

  • Anonymous's avatar
    Anonymous
    Not applicable

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

    • Anonymous's avatar
      Anonymous
      Not 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. 

      • Anonymous's avatar
        Anonymous
        Not applicable

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

         

        COUNT_Emp_id = COUNT('Table'(Emp_ID))