Forum Discussion

kattlees's avatar
kattlees
Post Patron
9 years ago
Solved

Count values from multiple columns into one.

I am trying to get a headcount of employees in a matrix. Each employee is assigned a "class" based on full time hourly, full time salary, PRN, or how part time.  How do I get the columns to show the ...
Need Help
Tutorial Requests
  • kattlees's avatar
    kattlees
    9 years ago

    I created a new column and grouped the classes by using =LEFT(Fieldname, # of characters) and it worked.

haozhong's avatar
haozhong
Resolver I
9 years ago

Flat table as in

 

RN | Class 1A 8833 | Class 1 | 2 |

RN | Class 3 8833 | Class 3 | 1 |

 

Easier to count that way in power BI or pivot tables in excel

 

just my opinion

 

 

kattlees's avatar
kattlees
Post Patron
9 years ago

I created a new column and grouped the classes by using =LEFT(Fieldname, # of characters) and it worked.