Issue in Pivot table

[bhuprakash]

Dear All,

I am attaching the dashboard and in the "Average Reporting per day" Data should reflect like below -

Row Labels	SA-I	SA-II	Grand Total
Below 3	104	138	242
More than 3	15	30	45
Grand Total	119	168	287

But in my dashboard only total values are coming. So request you to correct it.

2- I have employee details in Activity counts file and Activity done data in ActivityDetails_Master file. "Average Reporting per day" and

"working days per user" is giving correct data but it is failing is a employee has not done any activity because ActivityDetails_Master table has only employee details who have done activity. so how can i include those employee in the pivot.

[bhuprakash]

Hi Nimesh,

suppose those 3 employees have not done activity then result should come like below-

[bhuprakash]

Hi Nimesh,

Waiting for your kind revert.