Hi
I am attaching two screen shots for a detail explaination.
As you can see the blue lines are Entry lines which have Lines and Grlines under it(as child)
If you see E column which has Journal Entry Number and F column which has User id column.
And within same the Journal Entry Number column there might be different number of users with different user ids.
Hence i have created a Pivot table for the first five columns for this case.
The 2nd screenshot i filtered the grouping level column that has only the Lines and Grlines(No Entry level) and all the Journal Entry Numbers such as MTX-10001158,MTX-10001163 etc and all the User ids that fall under its respective Journal Entry Number.
Here I want to know whether i can get the Distinct or Uniqe Count of the different User ids within the same Journal Entry Number column.
Example in the 1st screenshot that has MTX-10001158 Journal Entry Number has
USER95
USER94
USER95
USER94
in the line and grlines level.
so i want count=2 for User id USER94
and count = 2 for User id USER95 within the same Journal Entry using Pivot table and so on for all the Journal Entry Numbers.
That is Distinct count of different user ids within the same Journal Entry Number using pivot table and
if possible the sum of count of user ids distict count.(example count =2 for user94 and count for user95 is 2 so sum is 2+2=4)
Please help me with this query.
Thank you.
Bookmarks