1 pivot out of 2 columns, but different ranges

Dear all,

I want to make a pivot with how often an ID was used during that week. For example ID C7214 in week 3 (3 times). This is the count function, I can manage this one.

But now the hard part. I also want to know how often the unique ID is used that week.. For example ticket C7214 in week 3 (1 time).

I can make two different pivot's out of it by removing all the duplicates, but then I have two seperated pivot and I want to have one if it's possible.

Kind regards!

Book.xlsx

[edit] Maybe this post should be in the other subforum about pivot. I apologize for this. Please move if it should be over there. Thnx! [/edit]

Hi Monzi,

I also want to know how often the unique ID is used that week.. For example ticket C7214 in week 3 (1 time).

I believe the result will always be 1 in such case... even if C7214 is used 5 times in the week 3.. the result will be 1 (1 time)... unless you consider how many times C7214 will be used across all weeks .. see the attached pivot. thanks.

Book.xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>

Everything can be ascertained there only.. see the revised workbook:-

Book.xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>

yes.. you need to customized this as I did

Regards,
DILIPandey

<click on below 'star' if this helps>