Hi,
I have a problem with pivot table.
I added attachment.
From table like this:
Company Process document 1 document 2 document 3
Google Process 1 lack lack send
Google Process 2 send lack lack
Microsoft Process 1 lack send send
I would like to get table for report like this:
Company type of lacking documents Count of documents
Google Document 1 1
Google Document 2 2
Google Document 3 1
Microsoft Document 1 1
Can anyone help me please?
I will be grateful,
thank you in advance,
Jacek Antek
Hi,
I fear your layout will not work for your requirements. Your table requires normalising before it can produce what you need. The ideal table would have 4 columns:
Company
Process
Document number
Status
and there would be multiple rows for each company and process combination - one for each document.
Company Process Document number Status Process 1 lack Process 1 lack Process 1 send Process 2 send Process 2 lack Process 2 lack Microsoft Process 1 lack Microsoft Process 1 send Microsoft Process 1 send
This will then permit you to create the required pivot table:
Status lack Company Document number Count of Process Microsoft Grand Total
Don
Please remember to mark your thread 'Solved' when appropriate.
Thank you for your response.
Hmm it is required to change the source table ? Oh no, it would be not easy.
best regards,
Jacek Antek
I have found the solution :
http://datapigtechnologies.com/blog/...-a-pivottable/
This trick is awesome.
Best Regards,
Jacek Antek
An easy way to achieve this effect with the addition of Power Query
Thank you stasinek for yor solution.
The problem with query is that you have to have this addition installed on your computer.
Method from the link above is better - it can be used everywhere without installing any adds.
Best Regards,
Jacek Antek
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks