Forum Discussion
Count of Measure
If I'm understanding correctly you can just use group category and account in a matrix to create the top table.
Add distinct employee id count into the value for the matrix. You don't need a new measure drag emp id in and change set the aggregation from the down arrow menu in the values list.
As it's based on the same data it would cross highlight/filter.
Memorable MemberIf I'm understanding correctly you can just use group category and account in a matrix to create the top table.
Add distinct employee id count into the value for the matrix. You don't need a new measure drag emp id in and change set the aggregation from the down arrow menu in the values list.
As it's based on the same data it would cross highlight/filter.
I created a summarized table for all entries then created the Hrs Grp category as a calculated column on that table. I then followed your steps and it worked!
The bottom table also gets filtered already when I select any Site-Category combination.
Only remaining issue I have is getting the data on the top table to show correctly on the chart. I dont have the % of Row Total available as value. Currently, it's on % of Grand Total.
- stretcharm
Cool. My next step would have been to create a summary table if the row level group is not going to work.
I did mine in as a reference of the first table and grouped in M adding a conditional column for the hr group.
I created a composite key of Account + EmpID to join the two tables.
Not sure why you've not got % of row. I get % of grand, column and row options.