Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Our Experts!
I have loaded data relating to (MAY,JUN,JULY,AUG,SEP & OCT) but what is appeared in the table except part of JUL & no data for AUG,SEP & OCT. But if I select those Months individually using list box for Months, it is appeared. Can some one explain me the reason for that. I may present the excel too.
Thanks
Neville
Date/Month(As per the Plan) | Person assigned for Visit | Branch to be visited | Ammended_Plan | Person visited | Branch visited |
18-May-17 | Neville | Embilipitiya | 25-May-17 | Neville | Embilipitiya |
19-May-17 | Neville | Kahawatta | 19-May-17 | ||
30-May-17 | Neville | Godakawela | 25-May-17 | Neville | Godakawela |
30-May-17 | Neville | Pallebedda | 25-May-17 | Neville | Pallebedda |
17-May-17 | Vernon | Thanamalwila | 18-May-17 | Vernon | Thanamalwila |
23-May-17 | Vernon | Kalawana | 23-May-17 | ||
19-May-17 | Vernon | Pelmadulla | 19-May-17 | ||
22-May-17 | Mahesh | Eheliyagoda | 19-May-17 | Mahesh | Eheliyagoda |
25-May-17 | Mahesh | Kiriella | 19-May-17 | Mahesh | Kiriella |
22-May-17 | Mahesh | Kuruwita | 19-May-17 | Mahesh | Kuruwita |
26-May-17 | Iresha | Middeniya | 23-May-17 | Iresha | Middeniya |
26-May-17 | Iresha | Angunakolapelessa | 23-May-17 | Iresha | Angunakolapelessa |
30-May-17 | Iresha | Balangoda | |||
20-Jun-17 | Neville | Kiriella | 29-Jun-17 | Neville | Kiriella |
22-Jun-17 | Neville | Kalawana | 26-Jun-17 | Neville | Kalawana |
28-Jun-17 | Neville | Pelmadulla | 27-Jun-17 | Neville | Pelmadulla |
28-Jun-17 | Neville | Balangoda | 27-Jun-17 | Neville | Balangoda |
23-Jun-17 | Vernon | Embilipitiya | 26-Jun-17 | Vernon | Embilipitiya |
19-Jun-17 | Vernon | Angunakolapelessa | 20-Jun-17 | Vernon | Angunakolapelessa |
19-Jun-17 | Vernon | Godakawela | 26-Jun-17 | Vernon | Godakawela |
21-Jun-17 | Mahesh | Middeniya | 27-Jun-17 | Mahesh | Middeniya |
26-Jun-17 | Mahesh | Kahawatta | 23-Jun-17 | Mahesh | Kahawatta |
21-Jun-17 | Mahesh | Pallebedda | 23-Jun-17 | Mahesh | Pallebedda |
22-Jun-17 | Iresha | Eheliyagoda | 22-Jun-17 | Iresha | Eheliyagoda |
22-Jun-17 | Iresha | Kuruwita | 22-Jun-17 | Iresha | Kuruwita |
27-Jun-17 | Iresha | Thanamalwilla | 27-Jun-17 | Iresha | Thanamalwilla |
21-Jul-17 | Neville | Eheliyagoda | 21-Jul-17 | Neville | Eheliyagoda |
19-Jul-17 | Neville | Kiriella | 19-Jul-17 | Neville | Kiriella |
21-Jul-17 | Neville | Kuruwita | 21-Jul-17 | Neville | Kuruwita |
27-Jul-17 | Neville | Thanamalwila | 28-Jul-17 | Thanamalwila | |
21-Jul-17 | Vernon | Middeniya | 27-Jul-17 | Vernon | Middeniya |
19-Jul-17 | Vernon | Angunakolapeless | 27-Jul-17 | Vernon | Angunakolapeless |
19-Jul-17 | Vernon | Godakawela | 26-Jul-17 | Vernon | Godakawela |
20-Jul-17 | Mahesh | Kalawana | 20-Jul-17 | Mahesh | Kalawana |
28-Jul-17 | Mahesh | Pelmadulla | 28-Jul-17 | Mahesh | Pelmadulla |
28-Jul-17 | Mahesh | Balangoda | 28-Jul-17 | Mahesh | Balangoda |
24-Jul-17 | Iresha | Embilipitiya | 24-Jul-17 | Iresha | Embilipitiya |
26-Jul-17 | Iresha | Kahawatta | 21-Jul-17 | Iresha | Kahawatta |
21-Jul-17 | Iresha | Pallebedda | 21-Jul-17 | Iresha | Pallebedda |
22-Aug-17 | Neville | Thanamalwila | 25-Aug-17 | Neville | Thanamalwila |
18-Aug-17 | Neville | Kalawana | 18-Aug-17 | Neville | Kalawana |
25-Aug-17 | Neville | Pelmadulla | 22-Aug-17 | Neville | Pelmadulla |
25-Aug-17 | Neville | Balangoda | 22-Aug-17 | Neville | Balangoda |
24-Aug-17 | Vernon | Embilipitiya | 24-Aug-17 | Vernon | Embilipitiya |
21-Aug-17 | Vernon | Middeniya | 21-Aug-17 | Vernon | Middeniya |
21-Aug-17 | Vernon | Pallebedda | 21-Aug-17 | Vernon | Pallebedda |
17-Aug-17 | Mahesh | Eheliyagoda | 17-Aug-17 | Mahesh | Eheliyagoda |
23-Aug-17 | Mahesh | Kiriella | 23-Aug-17 | Mahesh | Kiriella |
17-Aug-17 | Mahesh | Kuruwita | 17-Aug-17 | Mahesh | Kuruwita |
30-Aug-17 | Iresha | Angunakolapelessa | 29-Aug-17 | Iresha | Angunakolapelessa |
16-Aug-17 | Iresha | Kahawatta | 16-Aug-17 | Iresha | Kahawatta |
30-Aug-17 | Iresha | Godakawela | 16-Aug-17 | Iresha | Godakawela |
27-Sep-17 | Neville | Embilipitiya | 25-Sep-17 | Neville | Embilipitiya |
21-Sep-17 | Neville | Middeniya | 25-Sep-17 | Neville | Middeniya |
19-Sep-17 | Neville | Thanamalwila | 19-Sep-17 | Neville | Thanamalwila |
21-Sep-17 | Neville | Pallebedda | 19-Sep-17 | Neville | Pallebedda |
26-Sep-17 | Vernon | Kalawana | 26-Sep-17 | Vernon | Kalawana |
20-Sep-17 | Vernon | Pelmadulla | 20-Sep-17 | Vernon | Pelmadulla |
20-Sep-17 | Vernon | Balangoda | 20-Sep-17 | Vernon | Balangoda |
29-Sep-17 | Mahesh | Angunakolapelessa | 27-Sep-17 | Mahesh | Angunakolapelessa |
19-Sep-17 | Mahesh | Kahawatta | 19-Sep-17 | Mahesh | Kahawatta |
21-Sep-17 | Mahesh | Godakawela | 27-Sep-17 | Mahesh | Godakawela |
25-Sep-17 | Iresha | Eheliyagoda | 26-Sep-17 | Iresha | Eheliyagoda |
21-Sep-17 | Iresha | Kiriella | 26-Sep-17 | Iresha | Kiriella |
25-Sep-17 | Iresha | Kuruwita | 26-Sep-17 | Iresha | Kuruwita |
25-Oct-17 | Mahesh | Eheliyagoda | 25-Oct-17 | Mahesh | Eheliyagoda |
25-Oct-17 | Mahesh | Kuruwita | 25-Oct-17 | Mahesh | Kuruwita |
27-Oct-17 | Vernon | Embilipitiya | 27-Oct-17 | Vernon | Embilipitiya |
19-Oct-17 | Vernon | Middeniya | 19-Oct-17 | Vernon | Middeniya |
25-Oct-17 | Vernon | Thanamalwila | 25-Oct-17 | Vernon | Thanamalwila |
20-Oct-17 | Iresha | Angunakolapelessa | 20-Oct-17 | Iresha | Angunakolapelessa |
17-Oct-17 | Iresha | Kahawatta | 17-Oct-17 | Iresha | Kahawatta |
26-Oct-17 | Neville | Kalawana | 24-Oct-17 | Neville | Kalawana |
20-Oct-17 | Neville | Pelmadulla | 20-Oct-17 | Neville | Pelmadulla |
20-Oct-17 | Iresha | Godakawela | 17-Oct-17 | Iresha | Godakawela |
27-Oct-17 | Mahesh | Pallebedda | 27-Oct-17 | Mahesh | Pallebedda |
20-Oct-17 | Neville | Balangoda | 20-Oct-17 | Neville | Balangoda |
19-Oct-17 | Sineka | Kiriella | 19-Oct-17 | Sineka | Kiriella |
Try this
SUM(AGGR(COUNT(DISTINCT([Person assigned for Visit])),[Branch to be visited],[Branch visited], SET_MONTH))
SUM(AGGR(COUNT(DISTINCT([Person visited])),[Branch visited],[Branch to be visited], SET_MONTH))
Did you try to uncheck 'Suppress Zero Values' on the presentation tab of your chart properties?
Dear Sunny,
As you said when 0 values were unchecked, total Months are shown. But the two expressions I have written get the 0 values for most of the cases. But when each individual Months are selected picture is correct that too presented here. For you to check the expression too given.
SUM(AGGR(COUNT(DISTINCT([Person assigned for Visit])),[Branch to be visited],[Branch visited]))
SUM(AGGR(COUNT(DISTINCT([Person visited])),[Branch visited],[Branch to be visited]))
Thanks
Please let me know the reason as to why this happen so!
Try this
SUM(AGGR(COUNT(DISTINCT([Person assigned for Visit])),[Branch to be visited],[Branch visited], SET_MONTH))
SUM(AGGR(COUNT(DISTINCT([Person visited])),[Branch visited],[Branch to be visited], SET_MONTH))
Thank you very much dear sunny!
Your answer worked well!. Of course it was very fine.
Neville