Data Pivot output in single sheet having multiple tables

[Kaish]

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

[Raj]

@Kaish 
find the workflow attached

mark done if solved.

[Kaish]

Hi raj thanks for the wf, it's working for me but I want requirement in Pivpt for the 2nd Table as shown in the output and I also want the data in the single sheet of a excel file using the basic table tool for both the data, how to add those data in excel in table form 

[Raj]

@Kaish 
will you able to add a sample output in excel?

[Kaish]

Hi @Raj , I am working on organization data, if you understood my requirement could you please help me out?

[Kaish]

@Raj , As you can see there are 2 groupings in the 2nd table, 1 is for ID, 2md is for POC, then they have the count, how to achieve this ?

[Raj]

@Kaish 
refer this link
How to Create Merged Cells in Reports, Part 2 - Alteryx Community

this will help to format the report.
hope this helps.