Home » Questions » Computers [ Ask a new question ]

Excel and Pivot, avoiding buying another 3rd part component

Excel and Pivot, avoiding buying another 3rd part component

I hope someone can help me with this Excel problem, otherwise I'll need to buy another 3rd part control to handle the Pivot problem we've encountered. I know it's somewhat off-topic, but hopefully someone can/will help.

Asked by: Guest | Views: 42
Total answers/comments: 1
Guest [Entry]

"If you add a 'Helper' column to your data titled Count. Enter the number 1 into the Count column cells for each row of data you have.

ID Date Type Count
1 11.05.2009 0 1
2 12.05.2009 0 1
3 13.05.2009 1 1
4 14.05.2009 0 1
5 15.05.2009 0 1

Create the pivot table and insert a calculated field with the formula of =Type/Count

In the pivot table format the calculated field as a percentage.

Based on you sample data you should get this:

Week Percentage
20 20%"