Good morning,
In my pivot table, I have two organisations (Baroda and Leeds) and under each organisation, I have the list of items (skin products for certain skin conditions) and the corresponding no of patients.
I want a visualisation to compare both organisations in terms of products. Ideally, We want to compare items and no patients in each organisation. The number of patients column for both organisations has few values = 1.
Thank you in advance.
Last edited by Jigneshbharati; 11-11-2021 at 07:04 AM.
You want to see the number of unique products per organisation.
Important : as 1st step in creating your pivottable, be sure to select "add data to the model" (see screenshot in dutch)
When you do so, you can, later, select sum, average, ... to get details of you items.
When you selected in that 1st step "add data to the model", you also get "unique number" as last option.
Last edited by AliGW; 11-11-2021 at 12:52 PM.
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
I am so sorry. I don't get what you mean.
I have attached the graph that I tried to create but there are problems.
In the bar chart, Leeds is shown first and then Baroda whereas, in the Pivot, it is the other way around. Products whose value is equal to 1 have no corresponding bar or if it is, it's not ideal.
Both lists have some items common so ideally, you want to compare them in a logical manner. I am so sorry I don't have any stars to thank you.
Kind Regards
Thank you for your help!
Dear moderators,
I would be grateful if you could delete the following thread as it's very unclear and creating more confusion. I am so sorry for the confusion
https://www.excelforum.com/excel-cha...vot-table.html
Thank you in advance!
Kind Regards
Jignesh
Last edited by Jigneshbharati; 11-11-2021 at 09:18 AM.
Why don't you upload your workbook and manually add the results you expect.
Your original post is largely meaningless without being able to see your workbook
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thank you. I would really appreciate if you delete this post for me. I will create a scenario and post another thread soon but please delete this thread for me.
Kind regards,
Jignesh
We are not in the habit of deleting threads.
If your new scenario is related in any way to this data or request then just add the workbook and any new clarification in a post here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks