Hi All I have a dataset where I want to get my output in a single sheet having different pivot table results, how can I perform ?
ID POC Age Bucket
1 Sam 1 0-1
1 Dan 2 2-5
3 John 1 0-1
4 Tom 4 2-5
3 Sam 1 0-1
6 John 1 0-1
4 Ravi 7 >5
Here in this data I want 2 results:
1) I want the count of of Age in which all the age which is 1 should be counted and in other column count of age apart from 1, and then a third column which will sum up the count values
ex: Age Count(1) Age Count(Others) Sum of Count
4 3 7
2) I want one Pivot data in the same sheet having summary of data in which I want to show ID, POC and the Bucket in which I will have the count, how can we achieve this ?
ID POC Bucket
0-1 2-5 >5
1 Sam 2
Dan 1
3 John 1
Sam 1
4 Tom 1
Ravi 1
6 John 1
I want these data in my excel sheet in the same sheet I want both the data , kindly guide me and Kindly let me know the solution, I will be very grateful
