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

To make things easier, if you are pulling data, pull them in a flat table in excel then add additional column to group them class 1, class 2 etc in excel using a separate lookup table.

 

Then use power BI to read it

 

 

 

 

kattlees's avatar
kattlees
Post Patron
9 years ago

Not following the pulling them into a flat table in excel?   We pull directly from an sql database. I have added new columns to combine first and last name, etc. Just can't figure out the counts.

  • 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.