Create pivot table measure in data load?

[CreepyCatLady]

Hello helpful people.

I am going to do my best to ask this question in a way that makes sense. I have a pivot table:

The field "Count of Machines" is a field calculated by the pivot table that tells how many HOST_NAMEs match to any given Primary Users. I need that field in my data load so I can create visualizations based on it. Does that make sense? How can I do that? 

Thanks.

😸

[vinieme12]

What visualization exactly do you want to create?

[CreepyCatLady]

Ultimately I'll need to create several. The first one will be a table that will show User, how many devices, device name(s), logon hours, and most recent logon date(s)

Currently I have all those fields except how many devices, which is what the pivot table shows.

[vinieme12]

You can count them as you are doing now!

[CreepyCatLady]

I know I must seem incredibly dense, but currently the pivot table is doing the calculation. I don't know how to translate that to a function or into script.

[vinieme12]

can you post some sample dataset that best represents your actual data- in excel, and also do  a mockup up of the expected output

[CreepyCatLady]

I am so sorry. I knew this was going to be difficult for me to explain. Thank you for your patience.

What I currently have is this:

What I need to be able to add is this:

I don't know how to get the # of machines value nor whether the device is primary or secondary (that would be based on logged on hours). All I'm asking about in this question is the # of machines, I figured the Primary/Secondary question is another subject and will require another message board post.

[vinieme12 · Accepted solution]

Try below for count of machines by users

Count(total <PrimaryUser> distinct Hostname)

[CreepyCatLady]

This works! Thank you!