Creating a new pivot Table

[sbadal11]

I have been watching your U-Tube regarding the creation of pivot table and dashboards and I followed your written materials and am having some problems creating the pivot table from the get go. So, will you be kind and please shed some light and offer some suggestions as to why I am not getting the correct format of Date. I really appreciate your help and thanks for your cooperation's.


This is extremely a simple excel data and for some reason it doesn't display it correctly ;

THIS IS THE RAW DATA:

[TABLE="width: 273"]
<tbody>[TR]
[TD]VP Analyst
[/TD]
[TD]Date Sent to Requestor
[/TD]
[TD]Requestor Response Date
[/TD]
[/TR]
[TR]
[TD]Brian
[/TD]
[TD]04/29/19
[/TD]
[TD]04/30/19
[/TD]
[/TR]
[TR]
[TD]Brian
[/TD]
[TD]04/29/19
[/TD]
[TD]04/30/19
[/TD]
[/TR]
[TR]
[TD]Brian
[/TD]
[TD]04/29/19
[/TD]
[TD]04/30/19
[/TD]
[/TR]
[TR]
[TD]Ruthie
[/TD]
[TD]05/09/19
[/TD]
[TD]05/09/19
[/TD]
[/TR]
[TR]
[TD]Scott
[/TD]
[TD]05/09/19
[/TD]
[TD]05/09/19
[/TD]
[/TR]
</tbody>[/TABLE]

The Pivot Table:

[TABLE="width: 529"]
<tbody>[TR]
[TD]Row Labels
[/TD]
[TD]Count of Date Sent to Requestor
[/TD]
[TD]Count of Requestor Response Date
[/TD]
[/TR]
[TR]
[TD]Brian
[/TD]
[TD]3
[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD]Ruthie
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]Scott
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]Grand Total
[/TD]
[TD]5
[/TD]
[TD]5
[/TD]
[/TR]
</tbody>[/TABLE]


For some reason when I am trying to create the pivot table and move the appropriate columns and the final result shows no dates and instead comes up with number of Analysts and not showing the actual dates and then when I change the field to show dates through Format Cell, then I get the following:
[TABLE="width: 529"]
<tbody>[TR]
[TD]Row Labels[/TD]
[TD] Count of Date Sent to Requestor
[/TD]
[TD] Count of Requestor Response Date
[/TD]
[/TR]
[TR]
[TD]Brian
[/TD]
[TD] 01/03/00
[/TD]
[TD] 1/3/00
[/TD]
[/TR]
[TR]
[TD]Ruthie
[/TD]
[TD] 01/01/00
[/TD]
[TD] 1/1/00
[/TD]
[/TR]
[TR]
[TD]Scott
[/TD]
[TD] 01/01/00
[/TD]
[TD] 1/1/00
[/TD]
[/TR]
[TR]
[TD]Grand Total
[/TD]
[TD] 01/05/00
[/TD]
[TD] 1/5/00
[/TD]
[/TR]
</tbody>[/TABLE]

 

[sandy666]

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td]VP Analyst[/td][td]Date Sent to Requestor[/td][td]Requestor Response Date[/td][td][/td][td=bgcolor:#DDEBF7]VP Analyst[/td][td=bgcolor:#DDEBF7]Date Sent to Requestor[/td][td=bgcolor:#DDEBF7]Requestor Response Date[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Brian[/td][td]

29/04/2019​

[/td][td]

30/04/2019​

[/td][td][/td][td]Brian[/td][td]

29/04/2019​

[/td][td]

30/04/2019​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Brian[/td][td]

29/04/2019​

[/td][td]

30/04/2019​

[/td][td][/td][td]Ruthie[/td][td]

09/05/2019​

[/td][td]

09/05/2019​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Brian[/td][td]

29/04/2019​

[/td][td]

30/04/2019​

[/td][td][/td][td]Scott[/td][td]

09/05/2019​

[/td][td]

09/05/2019​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Ruthie[/td][td]

09/05/2019​

[/td][td]

09/05/2019​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]Scott[/td][td]

09/05/2019​

[/td][td]

09/05/2019​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]
[/table]

Design:
- Subtotals off
- Grand Totals off
- Report Layout: tabular form

 

[sbadal11]

Hi Sandy,
I really do appreciate showing me what I was missing, thanks a lot One other question I have if I add more data to my pivot table, can I later create a graphical dashboard (Line chart, Pie chart, etc.) to them and if so, should I just highlight the entire pivot table to creat these or there is another way that you can suggest?
Again, thanks a million for all your help and understanding.
Rgds,
Samson

 

[sandy666]

select any cell inside PivotTable then from the ribbon - Insert - Recommended Charts or Pivot Chart

 

[sbadal11]

select any cell inside PivotTable then from the ribbon - Insert - Recommended Charts or Pivot Chart

Thanks Sandy, much appreciated

 

[sandy666]

You are welcome

Have a nice day